how do I use +-*/ in one formula
 

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

how do I use +-*/ in one formula
 

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

--
Kind regards,

Niek Otten

"topjob" wrote in message ...
| A1 B1 C1 D1
| 2 4 3 2
| 2
| 2
| 2
| 2
| how do i add A1 *B1 -C1 and then / it by D1

how do I use +-*/ in one formula
 

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

"topjob" wrote in message ...
| 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

how do I use +-*/ in one formula
 

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

"topjob" wrote in message
...


"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

"topjob" wrote in message
...
| 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

how do I use +-*/ in one formula
 

=(A1*B1-C1)/D1


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"topjob" wrote in message
...
A1 B1 C1 D1
2 4 3 2
2
2
2
2
how do i add A1 *B1 -C1 and then / it by D1

how do I use +-*/ in one formula
 

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" wrote in message
...
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

"topjob" wrote in message
...


"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

"topjob" wrote in message
...
| 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

how do I use +-*/ in one formula
 

YES, exactly what I needed Thankyou

"Paul B" wrote:

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" wrote in message
...
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

"topjob" wrote in message
...


"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

"topjob" wrote in message
...
| 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

how do I use +-*/ in one formula
 

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

"topjob" wrote in message
...
YES, exactly what I needed Thankyou

"Paul B" wrote:

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" wrote in message
...
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

"topjob" wrote in message
...


"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

"topjob" wrote in message
...
| 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