AS 0 is the answer to more than one set of criteria the formula can be
simplified a little. I have started at the bottom of your list and
worked up, so the last condition is 0

You probably will want to check these but try

In M102
=if(and(q102=”Y”,R102=”Y”,S102=”Y”),
P102*ALA_CF,if(and(q102=”Y”,R102=”Y”), (P102*ALA_CF)+((P102*ALA_SU)/2),
if(and(q102=”Y”,s102=”Y”), (P102*ALA_CF)+((P102*ALA_RF)/2),
if(q102=”Y”,P102,0))))

In M103
=if(and(q102=”Y”,R102=”Y”,S102=”Y”),
P102*ALA_RF,if(and(R102=”Y”,S102=”Y”), (P102*ALA_RF)+((P102*ALA_CF)/2),
if(and(q102=”Y”,r102=”Y”), (P102*ALA_RF+((P102*ALA_SU)/2),
if(R102=”Y”,P102,0))))

In M104
=if(and(q102=”Y”,R102=”Y”,S102=”Y”),
P102*ALA_SU,if(and(R102=”Y”,S102=”Y”), (P102*ALA_SU+((P102*ALA_CF)/2),
if(and(q102=”Y”,s102=”Y”), (P102*ALA_RF+((P102*ALA_RF)/2),
if(s102=”Y”,P102,0))))

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=542806