Fine tuning if statement....
Derek,
Before the logic of you formula, what values of "O4-N4" are you expecting
and (more importantly) what is the user seeing, with the formatting of those
cell.
e.g. Really O4-N4=0.1249999999999999 but is shown as 0.125. Do you consider
these equal ?
NickHK
"Derek Witcher" wrote in message
om...
I think that something is missing but this is the formula I need.
=IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too
Short","Run Time OK")) But here is the problem the true statements
work fine but the false statement does not work. What I am a trying
to get is if the false statement which is o4-n4<0.125% so anything
that falls between o4-n4<0.125% Run Time OK.
Any suggestions would be great. thanks in advance for the help.
|