Here is wat im trying to do.
i have 3 columns (Q/R/S) That have a "Y" or "N" in them. These are to
be the variables to decide the formula.

P=157.67

If only Q102="Y" then cell M102 = P102 cells M103 and M104=0
If only Q102="Y" then cell M103 = P102 cells M102 and M104=0
If only Q102="Y" then cell M104 = P102 cells M102 and M103=0
If Q102 and R102 = "Y" then cell M102 = (P102*ALA_CF)+((P102*ALA_SU)/2)
and cell M103 = (P102*ALA_RF+((P102*ALA_SU)/2) and cell M104=0
If Q102 and S102 = "Y" then cell M102 = (P102*ALA_CF)+((P102*ALA_RF)/2)
and cell M103=0 and cell M104 = (P102*ALA_RF+((P102*ALA_RF)/2)
If R102 and S102 = "Y" then cell M102=0 and cell M103=
(P102*ALA_RF)+((P102*ALA_CF)/2) and cell M104 =
(P102*ALA_SU+((P102*ALA_CF)/2)
if all 3 columns = "y" then M102 = (P102*ALA_CF and cell M103 =
(P102*ALA_RF) and cell M103 = (P102*ALA_RF)

i know it has to be setup right in the 3 lines but I couldnt get it to
work right.


Thanks


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