if FUNCTION

[Joe]

Hi,

Using the nested IF function, i have the following
function
=IF(AND(H18=2,OR(ROUNDDOWN(W18,0.5)>=1, ROUNDDOWN
(W18,0.5<2))),"Not Exceed SL2",IF(AND(H18=1,OR(ROUNDDOWN
(W18,0.5)>=0,ROUNDDOWN(W18,0.5)<=1)),"Not Exceed SL1",IF
(AND(H18=3,ROUNDDOWN(W18,0.5)<=3),"Not Exceed
SL3", "Exceed SL3"))

how can i display the message "Exceed SL2" as apply for
the above function?

thanks,

regards,
Joe

 

[Bob Phillips]

I think you have a logic problem, ROUNDOWN with .5 will not give an answer
between integers. The second value is the n umber of digits to round to, not
the amount. Try =FLOOR(W18,0.5).

When would it say Not Exceed SL2