Fine tuning if statement....

[Derek Witcher]

I think that something is missing but this is the formula I need.
=IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N4>0.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.

 

[nath]

-----Original Message-----
I think that something is missing but this is the formula I need.
=IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N4>0.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.
.
I think that you need to do :

=if((o4-n4)<>0.00125,"Run Time OK","Runtime too long")

I didnt fully understand your situation, but the above,
will

if the differnce between O and N is anything other than
0.125% then its OK otherwise too long.

Hope this helps

Nath.

 

[NickHK]

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]

What I am looking for is if the difference of O4-N4 is greater than
.125% give result if greater that .125% another result and if these (2)
fail then give another. =IF(O4-N4<0.125%,"Run Time Too
Long",IF(O4-N4>0.125%,"Run Time Too Short","Run Time OK"))

This formula works for the True results but for the false result does
not work. So what I am looking for is if my data falls within that
<>.125% to give true result.

Any suggestions on other ways would be fine as well.


Thanks for all help given.

 

[NickHK]

Derek,
Your works as expected if:
O4 & N4 are formatted as percentages
As said before O4-N4= EXACTLY 0.125%, not merely appearing to.

However, I'm still confused as to what "So what I am looking for is if my
data falls within that <>.125% to give true result" .
A diiference of 0.125% should return "Run Time OK" ?

NickHK

 

[Guest]

-----Original Message-----
I think that something is missing but this is the formula I need.
=IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N4>0.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.
.

 

[Don Guillett]

try starting at the top. an example
=IF(C3>5,"a",IF(C3>4,"b",IF(C3>3,"c","d")))