IF functions

  • Thread starter Thread starter pejy69
  • Start date Start date
P

pejy69

Hi all.

Need some help with the following:
=IF(F2=">50000",10%,IF(F2=">100000",14%,("5%")))
When i run this function everything shows as 5%, yet anything >100000 = 14%,
abd anything >50000 = 10%. Can anyone advise as to what is wrong with my IF
function.

Need help urgently
Thankyou in advance
 
Hi,

There's a couple of things. First take the percentages out of quotes and
they will return values and second revers the order of the statement so it
evaluates the higher value first.

=IF(F2>=100000,10%,IF(F2>=50000,14%,5%))

Mike
 
I did of course mean to change the percentages too!!

=IF(F2>=100000,14%,IF(F2>=50000,10%,5%))
 
Back
Top