Junior Member

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help in < or mathematical excel equations	Rolo	Excel Discussion (Misc queries)	2	February 12th 07 11:06 AM
excel equations for teachers	Marie	Excel Discussion (Misc queries)	4	October 10th 06 09:23 AM
solving equations using Excel	arnold_charming	Excel Programming	2	December 8th 05 09:25 AM
Excel equations	ATK	Excel Discussion (Misc queries)	3	October 3rd 05 09:05 PM
Excel equations...	thanatologist	Excel Discussion (Misc queries)	2	March 25th 05 01:25 AM

All times are GMT +1. The time now is 12:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us