ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Full page formulas (https://www.excelbanter.com/excel-discussion-misc-queries/256003-full-page-formulas.html)

Bigdaddykdk

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


David Biddulph[_2_]

Full page formulas
 
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)





All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com