how do I use +-*/ in one formula

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Niek Otten said:
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
Click to expand...
 
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, 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
 
YES, exactly what I needed Thankyou

Paul B said:
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
Click to expand...
 
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
 
Back
Top