MORE THAN ONE LOGIC TEST

[Guest]

How would you test the following:
=IF(D34>11.9999
,(D34*0.2095+3)+D34+G34>7000.(d34*.2015+3.00),IF(D34<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

 

[Lilliabeth]

Why a > 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+G34>7000.(d34*.2015+3.00)

What is you really want to do if D34 is greater than 11.48?

 

[Guest]

if you want to test for g34>11.9 And
g34>7000,=if(and(g34>11.9,g34>7000),"true","false")

 

[Guest]

oops the first g34 should be d34