Fine tuning if statement....
 

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.

Fine tuning if statement....
 

-----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-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.
.
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.

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.

Fine tuning if statement....
 

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-N40.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.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Fine tuning if statement....
 

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

"Derek Witcher" wrote in message
...

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-N40.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.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Fine tuning if statement....
 

-----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-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.
.

Fine tuning if statement....
 

try starting at the top. an example
=IF(C35,"a",IF(C34,"b",IF(C33,"c","d")))
--
Don Guillett
SalesAid Software

wrote in message
...

-----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-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.
.