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