View Single Post
  #1   Report Post  
revpeachy revpeachy is offline
Junior Member
 
Posts: 1
Wink Help/Check my Formula

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