Need help again. Is there a formula that will do an either or calculation.
Example: If B1 is A, B2 would be 100 but if B1 is B, B2 would be 89. There
could be as many as 13 possibilities for B1, each resulting in a different
result in B2. Also, if there is nothing entered in B1, B2 needs to be 0. I
currently am using the formula
=IF(B18="A+",100,0) in C18 and =IF(B18="A",100,0) in D18 and
=IF(B18="A-",93,0) in E18, etc, and then =SUM(C18:P18) in Q18 to show the
result.

Thanks much
--
dbconn