| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if less than greater than
Hello this is my formula =IF(L2=N2,"OK",IF(L2<=N2,"",IF(L2N2,"Needs
Approval",""))) plain english - there is a discount in column L and column N , lets say 5% . if the discount is the same or between 1 and 5 then OK if the discount is over 5% then "Needs approval" if the cells is blank then blank . the problem with my formula is that is the discount (in this case ) is less than 5% I get a blank instead of OK . How do I correct this ? thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater than # but less than # | Excel Worksheet Functions | |||
| Greater Than and less than HELP PLEASE | Excel Discussion (Misc queries) | |||
| If sum greater than 12 use 12 | Excel Discussion (Misc queries) | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
| IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Threaded Mode
