How to do if statements in Excel [Solved/Closed]

Report
-
 Emerbeamer -
Hello,

I am having a problem trying to get an if formula right.

If fig1 is +- 10% of fig2 I want it to say Fail

If fig1 is within 10% of fig2. I want is to say Pass

I'm just not sure how to phrase it.

If anyone could help I would really appreciate it as I am not great in excel.

Thanks :)




1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
116
use

=If((fig1/fig2)<0.1,"Pass","Fail")
Thanks a million!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!