| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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)))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gap check formula? | Excel Worksheet Functions | |||
| Can someone please check this formula | Excel Programming | |||
| Can someone check this formula please? | Excel Discussion (Misc queries) | |||
| Check box and and formula | Excel Discussion (Misc queries) | |||
| How do I set up a formula with a check box? | Excel Discussion (Misc queries) | |||
Threaded Mode
