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

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

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

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

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

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

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