Registered User Joined: 10/18/2008 Posts: 260
|
Hi Bruce,
A while ago you hleped me with the following formula;
(C < L1 AND O1 = C1) OR (C < L2 AND O2 = C2) OR (C < L3 AND O3 = C3)
How can I modifide the formula where
O1 = C1 or O1 is within .5% C1? Is that posible?
Thanks Bruce
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Try this:
(C < L1 AND (O1 = C1 OR (O1/C1 > .995 AND O1/C1 < 1.005))) OR (C < L2 AND O2 = C2) OR (C < L3 AND O3 = C3)
|
Registered User Joined: 10/18/2008 Posts: 260
|
Thank you
|