If Statement!!

P

PaulOakley

Hello,

I have an excel dilemma. Basically i need an advanced IF statement.
It needs to look at a cell first and if that Cell is greater than the
number one it needs to return fail for the whole formula, if it is less
than one it needs to check another field and if that is one or less it
will return a 'pass'.

This is how i think it should look,

=IF(D15>1,"Fail", IF(F15>1, "Pass"))

I think im wrong though!!

Thanks in advance for your help!
 
G

Guest

one <if> is more than enough.
you may do it this way:
=if(d15>criteria,"fail", "pass")
to read: id d15 is bigger than whatever then write a fail otherwise write a
pass.
 
G

Guest

Hi

One problem is that if the first IF is TRUE, it will not get to the second
IF. What happens if D15<1 and F15 <1? What if D15>1 and F15>1?

Food for thought.

Andy.
 
R

Ron Rosenfeld

Hello,

I have an excel dilemma. Basically i need an advanced IF statement.
It needs to look at a cell first and if that Cell is greater than the
number one it needs to return fail for the whole formula, if it is less
than one it needs to check another field and if that is one or less it
will return a 'pass'.

This is how i think it should look,

=IF(D15>1,"Fail", IF(F15>1, "Pass"))

I think im wrong though!!

Thanks in advance for your help!
Click to expand...


=IF(D15<=1,IF(F15<1,"Pass","Undefined"),"Fail")




--ron
 
P

PaulOakley

Hi,

Im still having problems with this, I have attached a zip file of the
document to try and show the problem more clearly, I have annotated the
sheet. Its really difficult trying to explain the problem in words!

Thanks in advance for your help,

Paul


+-------------------------------------------------------------------+
|Filename: Audit.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4547 |
+-------------------------------------------------------------------+
 
P

PaulOakley

Thanks guys, works perfectly cheers for your help, and preventing a fis
and a monitor coming into contact!

Cheers

Pau
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Conditional Formatting to Pass/Fail 2
Excel Conditioning Formatting 3
Access IIF Statement - If field is greater than other field by =/-percentage 0
If statement with dates 0
Returning Desired Results 5
IF Statement in a macro: 2
If Statement 1
Looking up a returned value defining a named range 2

Top