Prev: how do i calculate 2' x 4' x 4"
Next: dynamic defined name
From: Lost_in_Excel on 3 Mar 2010 04:45
Can somebody advise a newbie please?

I've got three IF functions that I am trying to combine:

=IF(B5>125000,SUM(B5*0.01),)
=IF(B5>250000,SUM(B5*0.05),)
=IF(B5>500000,SUM(B5*0.08),)

I keep hitting syntax errors and when I do combine two arguments the formula
doesn't work properly...

From: Jacob Skaria on 3 Mar 2010 04:55
Try the below

=B5*IF(B5>500000,0.08,IF(B5>250000,0.05,IF(B5>125000,0.01,0)))
=B5*LOOKUP(B5,{0,125001,250001,500001},{0,0.01,0.05,0.08})


--
Jacob


"Lost_in_Excel" wrote:

> Can somebody advise a newbie please?
>
> I've got three IF functions that I am trying to combine:
>
> =IF(B5>125000,SUM(B5*0.01),)
> =IF(B5>250000,SUM(B5*0.05),)
> =IF(B5>500000,SUM(B5*0.08),)
>
> I keep hitting syntax errors and when I do combine two arguments the formula
> doesn't work properly...
>
From: Mike H on 3 Mar 2010 04:59
Hi,

Try this

=IF(B5>500000,B5*0.08,IF(B5>250000,B5*0.05,IF(B5>125000,B5*0.01,"")))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Lost_in_Excel" wrote:

> Can somebody advise a newbie please?
>
> I've got three IF functions that I am trying to combine:
>
> =IF(B5>125000,SUM(B5*0.01),)
> =IF(B5>250000,SUM(B5*0.05),)
> =IF(B5>500000,SUM(B5*0.08),)
>
> I keep hitting syntax errors and when I do combine two arguments the formula
> doesn't work properly...
>
From: Bernard Liengme on 3 Mar 2010 07:57
A none IF alternative
=B5*LOOKUP(B5,{0,125000,250000,500000},{0,0.01,0.05,0.08})
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lost_in_Excel" <Lost_in_Excel(a)discussions.microsoft.com> wrote in message
news:0210A617-26BE-4CC9-A5A9-D0A307C8A191(a)microsoft.com...
> Can somebody advise a newbie please?
>
> I've got three IF functions that I am trying to combine:
>
> =IF(B5>125000,SUM(B5*0.01),)
> =IF(B5>250000,SUM(B5*0.05),)
> =IF(B5>500000,SUM(B5*0.08),)
>
> I keep hitting syntax errors and when I do combine two arguments the
> formula
> doesn't work properly...
>
From: Lost_in_Excel on 3 Mar 2010 09:46
Thanks for the help - it was the brackets that confused me and I never
thought of using LOOKUP a good lesson for me, much appreciated.

"Lost_in_Excel" wrote:

> Can somebody advise a newbie please?
>
> I've got three IF functions that I am trying to combine:
>
> =IF(B5>125000,SUM(B5*0.01),)
> =IF(B5>250000,SUM(B5*0.05),)
> =IF(B5>500000,SUM(B5*0.08),)
>
> I keep hitting syntax errors and when I do combine two arguments the formula
> doesn't work properly...
>
 | 
Pages: 1
Prev: how do i calculate 2' x 4' x 4"
Next: dynamic defined name