Posted to microsoft.public.excel.programming
|
|
Formula Help
If you are using 2003 you may only use 7 nested IF statements...
If this post helps click Yes
---------------
Jacob Skaria
"Randy" wrote:
That worked perfect....now, I have added this to another portion of a formula
and the last part (very last "If") of this again does not seem to work? Could
it be to long?
=IF(AND(F9=0,OR(E9="vg_2x1_1",E9="vg_2x1_2",E9="vg _2x1_3")),$P$9,IF(AND(F9=0,OR(E9="vg_2x2_1",E9="vg _2x2_2",E9="vg_2x2_3")),$P$13,IF(AND(F9=35,D9=2),$ K$9,IF(AND(F9=45,D9=2),$K$10,IF(AND(F9=60,D9=2),$K $11,IF(AND(F9=35,D9=3),$K$16,IF(AND(F9=45,D9=3),$K $17,IF(AND(F9=60,D9=3),$K$18,"nope")))))))
--
Randy Street
Rancho Cucamonga, CA
"Patrick Molloy" wrote:
try this fix
=IF(AND(F7=0,OR(E7="vg_2x1_1",E7="vg_2x1_2",E7="vg _2x1_3")),$P$9,IF(AND(F7=0,OR(E7="vg_2x2_1",E7="vg _2x2_2",E7="vg_2x2_3")),$P$13,"nope"))
"Randy" wrote:
Can anyone tell me what might be wrong with this formula? The second half is
not working...or maybe if there is an easier VB way to do this!
=IF(OR(F7=0,AND(E7="vg_2x1_1",E7="vg_2x1_2",E7="vg _2x1_3")),$P$9,IF(OR(F7=0,AND(E7="vg_2x2_1",E7="vg _2x2_2",E7="vg_2x2_3")),$P$13,"nope"))
Any assistance will be greatly appreciated. Thanks in advance for your time...
--
Randy Street
Rancho Cucamonga, CA
|