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
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
use

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