Previous Topic Next Topic

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




Related:

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
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses