how do I use +-*/ in one formula

[Guest]

A1 B1 C1 D1
2 4 3 2
2
2
2
2
how do i add A1 *B1 -C1 and then / it by D1

 

[Niek Otten]

Please be more precise
What exactly do you want to add, what to subtract (from what?) and divide by what?

--
Kind regards,

Niek Otten

| A1 B1 C1 D1
| 2 4 3 2
| 2
| 2
| 2
| 2
| how do i add A1 *B1 -C1 and then / it by D1

 

[Guest]

Please be more precise
What exactly do you want to add, what to subtract (from what?) and divide by what?

--
Kind regards,

Niek Otten

| A1 B1 C1 D1
| 2 4 3 2
| 2
| 2
| 2
| 2
| how do i add A1:A5 then *B1then -C1 and then divide the answer by D1

 

[Paul B]

topjob, try =(A1*B1-C1)/D1 is that what you need?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Peo Sjoblom]

=(A1*B1-C1)/D1


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Paul B]

topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

YES, exactly what I needed Thankyou

topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

Your welcome, thanks for the feedback

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003