Is IF the right way to combine these?
 

Can somebody advise a newbie please?

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

=IF(B5125000,SUM(B5*0.01),)
=IF(B5250000,SUM(B5*0.05),)
=IF(B5500000,SUM(B5*0.08),)

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

Is IF the right way to combine these?
 

Try the below

=B5*IF(B5500000,0.08,IF(B5250000,0.05,IF(B51250 00,0.01,0)))
=B5*LOOKUP(B5,{0,125001,250001,500001},{0,0.01,0.0 5,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(B5125000,SUM(B5*0.01),)
=IF(B5250000,SUM(B5*0.05),)
=IF(B5500000,SUM(B5*0.08),)

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

Is IF the right way to combine these?
 

Hi,

Try this

=IF(B5500000,B5*0.08,IF(B5250000,B5*0.05,IF(B51 25000,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(B5125000,SUM(B5*0.01),)
=IF(B5250000,SUM(B5*0.05),)
=IF(B5500000,SUM(B5*0.08),)

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

Is IF the right way to combine these?
 

A none IF alternative
=B5*LOOKUP(B5,{0,125000,250000,500000},{0,0.01,0.0 5,0.08})
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lost_in_Excel" wrote in message
...
Can somebody advise a newbie please?

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

=IF(B5125000,SUM(B5*0.01),)
=IF(B5250000,SUM(B5*0.05),)
=IF(B5500000,SUM(B5*0.08),)

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

Is IF the right way to combine these?
 

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(B5125000,SUM(B5*0.01),)
=IF(B5250000,SUM(B5*0.05),)
=IF(B5500000,SUM(B5*0.08),)

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