Is IF the right way to combine these?

[Lost_in_Excel]

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...

 

[Jacob Skaria]

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})

 

[Mike H]

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.

 

[Bernard Liengme]

A none IF alternative
=B5*LOOKUP(B5,{0,125000,250000,500000},{0,0.01,0.05,0.08})
best wishes

 

[Lost_in_Excel]

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.