Posted to microsoft.public.excel.worksheet.functions
|
|
multiple IF statements
try this idea. Notice I did the 0's first and worked from the top down.
=J9-IF(OR(J955,J9=42,J9=28,J9=14,J9=7),0,IF(OR(J942, J928,J914,J97),D21))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Tom" wrote in message
...
Hi gang,
my head is spinning around...what would be the best way to write this one?
In cell D20:
IF J9<7,D20=J9
IF J9=7,D20=0
IF J97<14,D20=J9-D21
IF J9=14, D20=0
IF J914<28,D20=J9-D21
IF J9=28, D20=0
IF J928<42,D20=J9-D21
IF J9=42, D20=0
IF J942<56, D20=J9-D21
thanks in advance!
|