Check/Help with Formula

[revpeachy]

Please could someone kindly check my formula: trying to show a number 1 when I have less then 100%; to show 2 when I am equal to or over 100% and finally a 3 when the percentage exceeds 111%. the first two work but cannot show the required number 3 for the final part of the sum....am sure it is something simple.

Many thanks



=IF(G4="","",IF(G4<100%,1,IF(G4>=100%,2,IF(G4>=111%,3))))

 

[Kranthi Kumar]

on first look, else case was missing in lowest if condition.
Try as following

=IF(G4<100%,1,IF(G4>=100%,2,IF(G4>=111%,3,"")))

 

[revpeachy]

Many thanks for your prompt reply; alas when i use the amended sum and say enter 113%, it produces a 2 and not the required 3......

 

[Debraj]

Or may be like this..

=IF(G2="","",IF(G2<100,1,IF(G2>=111,3,2)))

 

[revpeachy]

You complete star Debraj; that's why you're a ninja and I'm the newbie....perfect answer

Thank you