Thread: Excel equations
View Single Post
  #1   Report Post  
ldehn ldehn is offline
Junior Member
 
Posts: 1
Default Excel equations

I want to write an equation that says if E20, E30, E40, E50, and E60 then I would take C2*E2, plus C3*E3, plus C4*E4, plus C5*E5, plus C6*E6. So for example C2=400, C3=400, C4=450, C5=500, C6=550, E2=200, E3=0, E4=100, E5=0, and E6=150. What I want to get for a total is 207,500. Taking C2*E2+C4*E4+C6*E6. Can anyone help me?