If statement..Please help
 

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-N40.125%,"Check your run time","")

Any suggestions!!!

If statement..Please help
 

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-N40.125%,O4-N4<0.125%),"Check your run
time","")


-----Original Message-----
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-N40.125%,"Check your run time","")

Any suggestions!!!
.

If statement..Please help
 

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-N40.125%,"Run Time Too
Long","Run Time OK")

Good Luck

"Derek Witcher" wrote in message
om...
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-N40.125%,"Check your run time","")

Any suggestions!!!

If statement..Please help
 

"Frank & Pam Hayes" wrote in message news:<lty3d.3302$uz1.1434@trndny03...
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-N40.125%,"Run Time Too
Long","Run Time OK")

Good Luck

"Derek Witcher" wrote in message
om...
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-N40.125%,"Check your run time","")

Any suggestions!!!


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.

If statement..Please help
 

"Frank & Pam Hayes" wrote in message news:<lty3d.3302$uz1.1434@trndny03...
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-N40.125%,"Run Time Too
Long","Run Time OK")

Good Luck

"Derek Witcher" wrote in message
om...
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-N40.125%,"Check your run time","")

Any suggestions!!!


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.

If statement..Please help
 

Derek,

Here is the code you need:

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

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

Frank

"Derek Witcher" wrote in message
om...
"Frank & Pam Hayes" wrote in message
news:<lty3d.3302$uz1.1434@trndny03...
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-N40.125%,"Run Time Too
Long","Run Time OK")

Good Luck

"Derek Witcher" wrote in message
om...
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-N40.125%,"Check your run time","")

Any suggestions!!!


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.