How to do if statements in Excel

Solved/Closed

Emerbeamer - Mar 18, 2011 at 08:02 AM
Emerbeamer - Mar 18, 2011 at 08:24 AM

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

How to do if statements in Excel
How many if statements can you nest - Guide
How to take screenshot in excel - Guide
Number to words in excel - Guide
If then statements in excel - Guide
How to change author in excel - Guide

1 response

Answer 1 / 1

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 18, 2011 at 08:07 AM

use

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

Emerbeamer
Mar 18, 2011 at 08:24 AM

Thanks a million!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Similar discussions

Subscribe To Our Newsletter!