Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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 :)




See more

1 reply

Answer 1 / 1
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
 120
use

=If((fig1/fig2)<0.1,"Pass","Fail")
Report

Thanks a million!
Ask a question