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

How would you test the following:
=IF(D3411.9999
,(D34*0.2095+3)+D34+G347000.(d34*.2015+3.00),IF(D 34<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