View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lilliabeth
 
Posts: n/a
Default MORE THAN ONE LOGIC TEST


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+G347000.(d34*.2015+3.00)

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


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=508594