Prev: Formulate Entire Sheet
Next: when i save a file that i have worked on, excel7 closes down work.
From: Bigdaddykdk on 11 Feb 2010 00:54
How do I do this for every row?
Example:
=SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4)

From: "David Biddulph" groups [at] on 11 Feb 2010 03:52
The first question is what are you intending the SUM function to do in each
of your formulae?
In what way do you want =SUM(C4*0.5) to differ from =C4*0.5 ?
In what way do you want =SUM(E4*15) to differ from =E4*15 ?
In what way do you want =SUM(G4+F4+D4) to differ from =G4+F4+D4 ?
In what way do you want =SUM(I4-H4) to differ from =I4-H4 ?
If you don't understand what the SUM function does, try looking it up in
Excel help.

If you want to fill the formulae down a column, look at the topic "fill" in
Excel help.
--
David Biddulph


Bigdaddykdk wrote:
> How do I do this for every row?
> Example:
> =SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4)


 | 
Pages: 1
Prev: Formulate Entire Sheet
Next: when i save a file that i have worked on, excel7 closes down work.