IF functions

[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

 

[Mike H]

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

 

[Mike H]

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

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

 

[pejy69]

Thankyou very much.... worked wonders