Thread: Multiple Ifs
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default 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