If statement..Please help

[Derek Witcher]

Product Code# Units Per Unit Total Bottles Color Cav Act
Cycle Standard Cycle Run Time Calc Run Down time / Reason
601003500001 22 108 2376 NAT 2 10 11 2 3.3 Check your run time

This is the statement I am using but it only allows for items less
than .125%. I need to be able to check both less than and greater
than .125% as well as leaving the possible window open for good
calculations.

=IF(O4-N4>0.125%,"Check your run time","")

Any suggestions!!!

 

[Frank Kabel]

Hi
do you mean something like:
=IF(ABS(O4-N4)>0.125%,"Check your run time","")

or do you want an AND condition:
=IF(AND(O4-N4>0.125%,O4-N4<0.125%),"Check your run
time","")

 

[Frank & Pam Hayes]

Derek,

If I understand your problem correctly, you have a couple of choices. It
may be as simple as:

=IF(O4-N4<>0.125%,"Check your run time","Run Time OK") Please notice the
use of <>

Another alternative would be to use the nesting function to examine all
three possible outcomes as in:

=IF(O4-N4<0.125%,"Run Time Too Short",IF(O4-N4>0.125%,"Run Time Too
Long","Run Time OK")

Good Luck

 

[Derek Witcher]

Derek,

If I understand your problem correctly, you have a couple of choices. It
may be as simple as:

=IF(O4-N4<>0.125%,"Check your run time","Run Time OK") Please notice the
use of <>

Another alternative would be to use the nesting function to examine all
three possible outcomes as in:

=IF(O4-N4<0.125%,"Run Time Too Short",IF(O4-N4>0.125%,"Run Time Too
Long","Run Time OK")

Good Luck

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.

 

[Derek Witcher]

Derek,

If I understand your problem correctly, you have a couple of choices. It
may be as simple as:

=IF(O4-N4<>0.125%,"Check your run time","Run Time OK") Please notice the
use of <>

Another alternative would be to use the nesting function to examine all
three possible outcomes as in:

=IF(O4-N4<0.125%,"Run Time Too Short",IF(O4-N4>0.125%,"Run Time Too
Long","Run Time OK")

Good Luck

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.

 

[Frank & Pam Hayes]

Derek,

Here is the code you need:

=IF(O4-N4<0.125,"Run Time Too Long",IF(O4-N4>0.125,"Run Time Too Short","Run
Time OK"))

I think your using both the decimal and % sign was the error.

Frank