Hi all,
I need a formula that determines if a value passes or fails. basically, if cell g21 is ±15% of cell b7, then it passes. if it is more than ±15%, then it fails. I am at a loss for where to start. please help.
thanks,
ias
Hi all,
I need a formula that determines if a value passes or fails. basically, if cell g21 is ±15% of cell b7, then it passes. if it is more than ±15%, then it fails. I am at a loss for where to start. please help.
thanks,
ias
Try
=IF(OR(G2<B7*.85,G2>B7*1.15),"PASS","FAIL")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks, but that doesn't work. I find that if you replace the OR with an AND, it works. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks