software

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(D15gt;1,quot;Failquot;, IF(F15gt;1, quot;Passquot;))

I think im wrong though!!

Thanks in advance for your help!--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
View this thread: www.excelforum.com/showthread...hreadid=527527one lt;ifgt; is more than enough.
you may do it this way:
=if(d15gt;criteria,quot;failquot;, quot;passquot;)
to read: id d15 is bigger than whatever then write a fail otherwise write a
pass.quot;PaulOakleyquot; wrote:

gt;
gt; Hello,
gt;
gt; I have an excel dilemma. Basically i need an advanced IF statement.
gt; It needs to look at a cell first and if that Cell is greater than the
gt; number one it needs to return fail for the whole formula, if it is less
gt; than one it needs to check another field and if that is one or less it
gt; will return a 'pass'.
gt;
gt; This is how i think it should look,
gt;
gt; =IF(D15gt;1,quot;Failquot;, IF(F15gt;1, quot;Passquot;))
gt;
gt; I think im wrong though!!
gt;
gt; Thanks in advance for your help!
gt;
gt;
gt; --
gt; PaulOakley
gt; ------------------------------------------------------------------------
gt; PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
gt; View this thread: www.excelforum.com/showthread...hreadid=527527
gt;
gt;


=IF(D15gt;1,quot;Failquot;, IF(F15lt;=1, quot;Passquot;))

quot;PaulOakleyquot; wrote:

gt;
gt; Hello,
gt;
gt; I have an excel dilemma. Basically i need an advanced IF statement.
gt; It needs to look at a cell first and if that Cell is greater than the
gt; number one it needs to return fail for the whole formula, if it is less
gt; than one it needs to check another field and if that is one or less it
gt; will return a 'pass'.
gt;
gt; This is how i think it should look,
gt;
gt; =IF(D15gt;1,quot;Failquot;, IF(F15gt;1, quot;Passquot;))
gt;
gt; I think im wrong though!!
gt;
gt; Thanks in advance for your help!
gt;
gt;
gt; --
gt; PaulOakley
gt; ------------------------------------------------------------------------
gt; PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
gt; View this thread: www.excelforum.com/showthread...hreadid=527527
gt;
gt;

sorry, i misread the question. please drop my solytion.

quot;GGquot; wrote:

gt; one lt;ifgt; is more than enough.
gt; you may do it this way:
gt; =if(d15gt;criteria,quot;failquot;, quot;passquot;)
gt; to read: id d15 is bigger than whatever then write a fail otherwise write a
gt; pass.
gt;
gt;
gt; quot;PaulOakleyquot; wrote:
gt;
gt; gt;
gt; gt; Hello,
gt; gt;
gt; gt; I have an excel dilemma. Basically i need an advanced IF statement.
gt; gt; It needs to look at a cell first and if that Cell is greater than the
gt; gt; number one it needs to return fail for the whole formula, if it is less
gt; gt; than one it needs to check another field and if that is one or less it
gt; gt; will return a 'pass'.
gt; gt;
gt; gt; This is how i think it should look,
gt; gt;
gt; gt; =IF(D15gt;1,quot;Failquot;, IF(F15gt;1, quot;Passquot;))
gt; gt;
gt; gt; I think im wrong though!!
gt; gt;
gt; gt; Thanks in advance for your help!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; PaulOakley
gt; gt; ------------------------------------------------------------------------
gt; gt; PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=527527
gt; gt;
gt; gt;

Hi

One problem is that if the first IF is TRUE, it will not get to the second
IF. What happens if D15lt;1 and F15 lt;1? What if D15gt;1 and F15gt;1?

Food for thought.

Andy.

quot;PaulOakleyquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; I have an excel dilemma. Basically i need an advanced IF statement.
gt; It needs to look at a cell first and if that Cell is greater than the
gt; number one it needs to return fail for the whole formula, if it is less
gt; than one it needs to check another field and if that is one or less it
gt; will return a 'pass'.
gt;
gt; This is how i think it should look,
gt;
gt; =IF(D15gt;1,quot;Failquot;, IF(F15gt;1, quot;Passquot;))
gt;
gt; I think im wrong though!!
gt;
gt; Thanks in advance for your help!
gt;
gt;
gt; --
gt; PaulOakley
gt; ------------------------------------------------------------------------
gt; PaulOakley's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25103
gt; View this thread: www.excelforum.com/showthread...hreadid=527527
gt;
On Wed, 29 Mar 2006 05:27:25 -0600, PaulOakley
gt; wrote:

gt;
gt;Hello,
gt;
gt;I have an excel dilemma. Basically i need an advanced IF statement.
gt;It needs to look at a cell first and if that Cell is greater than the
gt;number one it needs to return fail for the whole formula, if it is less
gt;than one it needs to check another field and if that is one or less it
gt;will return a 'pass'.
gt;
gt;This is how i think it should look,
gt;
gt;=IF(D15gt;1,quot;Failquot;, IF(F15gt;1, quot;Passquot;))
gt;
gt;I think im wrong though!!
gt;
gt;Thanks in advance for your help!=IF(D15lt;=1,IF(F15lt;1,quot;Passquot;,quot;Undefinedquot;),quot;Failquot;)

--ron


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: www.excelforum.com/attachment.php?postid=4547 |
-------------------------------------------------------------------

--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
View this thread: www.excelforum.com/showthread...hreadid=527527I've clicked on your link and it says 'Invalid attachment'

Andy.

quot;PaulOakleyquot; gt; wrote
in message ...
gt;
gt; Hi,
gt;
gt; Im still having problems with this, I have attached a zip file of the
gt; document to try and show the problem more clearly, I have annotated the
gt; sheet. Its really difficult trying to explain the problem in words!
gt;
gt; Thanks in advance for your help,
gt;
gt; Paul
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Audit.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4547 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; PaulOakley
gt; ------------------------------------------------------------------------
gt; PaulOakley's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25103
gt; View this thread: www.excelforum.com/showthread...hreadid=527527
gt;

Here it is again, hopefully it will work this time -------------------------------------------------------------------
|Filename: Audit.zip |
|Download: www.excelforum.com/attachment.php?postid=4548 |
-------------------------------------------------------------------

--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
View this thread: www.excelforum.com/showthread...hreadid=527527Nope, sorry!

Andy.

quot;PaulOakleyquot; gt; wrote
in message ...
gt;
gt; Here it is again, hopefully it will work this time
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Audit.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4548 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; PaulOakley
gt; ------------------------------------------------------------------------
gt; PaulOakley's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25103
gt; View this thread: www.excelforum.com/showthread...hreadid=527527
gt;