#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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)

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
randomly does/doesn't print full page Joy Excel Discussion (Misc queries) 0 October 17th 09 07:22 PM
File view - full page Amanda Excel Discussion (Misc queries) 2 May 8th 08 09:08 AM
Rows not printing on full page Kelli Excel Discussion (Misc queries) 2 April 10th 07 07:42 PM
COPING FULL PAGE PATTENS TO ANOTHER PAGE alec Excel Worksheet Functions 1 November 29th 06 05:10 AM
I want 20 rows in excel to take up full A4 page Sillygoose Excel Worksheet Functions 1 April 6th 05 05:07 AM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"