Multiple Ifs
Since you are always adding .10*A2, you can use the following
construct:
=.10*A2*(IF(AND(B2=1,C212),1,0)+IF(AND(B2=2,C210 ),1,0)+...+...)
Also, if the pattern of your example continues (i.e. B2 starting from 1
and increasing by 1, C2 starting from 12 and decreasing by 2), you
could possible compact it all in a single formula:
=IF(C2=12-2*(B1-1),.10*A2,0)
HTH
Kostis Vezerides
|