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!
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!