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

Question

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

Report

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
Maximum if statements in excel - How-To - Excel
Multiple if statements in excel data validation - Forum - Excel
If statements in excel with dates - How-To - Excel
Multiple IF statements in Excel ✓ - Forum - Excel
If, then statement in Excel ✓ - Forum - Excel

1 reply

Ask a question

RWomanizer · Answer 1 · 2011-03-18T08:07:25-0400

Answer 1 / 1

RWomanizer

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

116
Mar 18, 2011 at 08:07 AM

use

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

Report

Emerbeamer
Mar 18, 2011 at 08:24 AM

Thanks a million!

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

1 reply

Your reply

Subscribe To Our Newsletter!