| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if less than greater than
Try:
IF(L2="","",IF(L2<=N2,"OK","Needs Approval")) -- Cheers macropod [Microsoft MVP - Word] "Wanna Learn" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if less than greater than
=IF(L2="","",IF(L2<=N2,"OK",IF(L2N2,"Needs Approval","")))
If this post helps click Yes --------------- Jacob Skaria "Wanna Learn" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if less than greater than
Hi
Try =IF(AND(L2<5,N2<5),"",IF(L2=N2,"OK",IF(L2<=N2,"",I F(L2N2,"Needs Approval")))) "Wanna Learn" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if less than greater than
Thank you Jacob. this is good. But I just noticed that some cells in column
N instead of a discount have a comment. there are several diffrent comments such as See Manager, discontinued etc etc. So I need to add that if the cell has text " Needs approval" Again thank you "Jacob Skaria" wrote: =IF(L2="","",IF(L2<=N2,"OK",IF(L2N2,"Needs Approval",""))) If this post helps click Yes --------------- Jacob Skaria "Wanna Learn" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if less than greater than
Let us know the conditions for those comments..
-- If this post helps click Yes --------------- Jacob Skaria "Wanna Learn" wrote: Thank you Jacob. this is good. But I just noticed that some cells in column N instead of a discount have a comment. there are several diffrent comments such as See Manager, discontinued etc etc. So I need to add that if the cell has text " Needs approval" Again thank you "Jacob Skaria" wrote: =IF(L2="","",IF(L2<=N2,"OK",IF(L2N2,"Needs Approval",""))) If this post helps click Yes --------------- Jacob Skaria "Wanna Learn" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if less than greater than
=IF(L2="","",IF(OR(L2N2,ISTEXT(N2)),"Needs Approval,"OK"))
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Wanna Learn" wrote: Thank you Jacob. this is good. But I just noticed that some cells in column N instead of a discount have a comment. there are several diffrent comments such as See Manager, discontinued etc etc. So I need to add that if the cell has text " Needs approval" Again thank you "Jacob Skaria" wrote: =IF(L2="","",IF(L2<=N2,"OK",IF(L2N2,"Needs Approval",""))) If this post helps click Yes --------------- Jacob Skaria "Wanna Learn" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
