Posted to microsoft.public.excel.worksheet.functions

jan kay

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help on Logic test!!!	jbf frylock	Excel Discussion (Misc queries)	5	January 9th 06 09:43 PM
logic test	toolman	Excel Discussion (Misc queries)	2	October 8th 05 01:37 PM
logic test	toolman	Excel Worksheet Functions	2	October 8th 05 04:28 AM
hpw do I logic test a cell then copy the row to diff. SS	Debi	Excel Worksheet Functions	4	October 5th 05 09:42 PM
Can wildcards be used in the Logic Test of an Excel "IF" function?	Monte	Excel Worksheet Functions	3	August 15th 05 01:25 PM

All times are GMT +1. The time now is 03:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us