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