software

How would you test the following:
=IF(D34gt;11.9999
,(D34*0.2095 3) D34 G34gt;7000.(d34*.2015 3.00),IF(D 34lt;12,(D34*0.465) D34))
this does not work I am trying to evaluate more than test for the computer
to pick which one is correct based on the values in d34 and g34
Janjp


Why a gt; symbol in your value if true argument? And what's the dot for?
There are also questionable parantheses.

What you have says if D34 is greater than 11.48 then you want to:

(D34*0.2095 3) D34 G34gt;7000.(d34*.2015 3.00)

What is you really want to do if D34 is greater than 11.48?--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: www.excelforum.com/member.php...oamp;userid=27741
View this thread: www.excelforum.com/showthread...hreadid=508594if you want to test for g34gt;11.9 And
g34gt;7000,=if(and(g34gt;11.9,g34gt;7000),quot;truequot;,quot;falsequot; )
--
paul
remove nospam for email addy!
quot;Lilliabethquot; wrote:

gt;
gt; Why a gt; symbol in your value if true argument? And what's the dot for?
gt; There are also questionable parantheses.
gt;
gt; What you have says if D34 is greater than 11.48 then you want to:
gt;
gt; (D34*0.2095 3) D34 G34gt;7000.(d34*.2015 3.00)
gt;
gt; What is you really want to do if D34 is greater than 11.48?
gt;
gt;
gt; --
gt; Lilliabeth
gt; ------------------------------------------------------------------------
gt; Lilliabeth's Profile: www.excelforum.com/member.php...oamp;userid=27741
gt; View this thread: www.excelforum.com/showthread...hreadid=508594
gt;
gt;

oops the first g34 should be d34
--
paul
remove nospam for email addy!
quot;paulquot; wrote:

gt; if you want to test for g34gt;11.9 And
gt; g34gt;7000,=if(and(g34gt;11.9,g34gt;7000),quot;truequot;,quot;falsequot; )
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Lilliabethquot; wrote:
gt;
gt; gt;
gt; gt; Why a gt; symbol in your value if true argument? And what's the dot for?
gt; gt; There are also questionable parantheses.
gt; gt;
gt; gt; What you have says if D34 is greater than 11.48 then you want to:
gt; gt;
gt; gt; (D34*0.2095 3) D34 G34gt;7000.(d34*.2015 3.00)
gt; gt;
gt; gt; What is you really want to do if D34 is greater than 11.48?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Lilliabeth
gt; gt; ------------------------------------------------------------------------
gt; gt; Lilliabeth's Profile: www.excelforum.com/member.php...oamp;userid=27741
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=508594
gt; gt;
gt; gt;