MrExcel Publishing
Your One Stop for Excel Tips & Solutions

need logic formula


Posted by Celeste on January 04, 2002 1:15 AM

i'm looking for a formula (no codes please) that would be (i guess) a logic formula, but i need a formula that has TWO logical tests, and one value if true, one value if false. for instance, this is what i need it to say:

IF S=0 AND U>=.01 THEN DIVIDE V/L IF NOT THEN DIVIDE V/S

hope you understand what i'm looking for, and i hope there's a formula!!!

TIA!!


Posted by Aladin Akyurek on January 04, 2002 1:25 AM

Celeste --

=IF(AND(S1=0,U1>=0.01),IF(L1,V1/L1,0),IF(S1,V1/S1,0))

will give you what you want. It also controls the computation by returning 0 in case a #DIV/0! can occur. It does however expect that S1 and U1 are numeric and neither houses a formula generated blank.

Aladin

========