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