Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MORE THAN ONE LOGIC TEST
if you want to test for g3411.9 And
g347000,=if(and(g3411.9,g347000),"true","false" ) -- paul remove nospam for email addy! "Lilliabeth" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MORE THAN ONE LOGIC TEST
oops the first g34 should be d34
-- paul remove nospam for email addy! "paul" wrote: if you want to test for g3411.9 And g347000,=if(and(g3411.9,g347000),"true","false" ) -- paul remove nospam for email addy! "Lilliabeth" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help on Logic test!!! | Excel Discussion (Misc queries) | |||
logic test | Excel Discussion (Misc queries) | |||
logic test | Excel Worksheet Functions | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
Can wildcards be used in the Logic Test of an Excel "IF" function? | Excel Worksheet Functions |