W
Wanna Learn
Hello this is my formula =IF(L2=N2,"OK",IF(L2<=N2,"",IF(L2>N2,"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
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