Thread
:
multiple IF statements
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
multiple IF statements
Duke's is best but mine could be used by subtracting j9
=J9-IF(OR(J955,J9=42,J9=28,J9=14,J9=7),j9,IF(OR(J942 ,J928,J914,J97),D21))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don Guillett" wrote in message
...
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett