ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to create a formula? (https://www.excelbanter.com/new-users-excel/124883-how-create-formula.html)

Zygy

How to create a formula?
 
What do I do to have a result appear automatically in F68 which is the
result of F67+C68+E68-D68. Currently I Copy and Paste on F67 & F68.



Bernard Liengme

How to create a formula?
 
In the cell type =F67+C68+E68-D68
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Zygy" wrote in message
...
What do I do to have a result appear automatically in F68 which is the
result of F67+C68+E68-D68. Currently I Copy and Paste on F67 & F68.




Zygy

How to create a formula?
 
As I said I copy and paste the formula already, but how do I create a
formula that would produce the result in F69,70,71, ect, ect ad infinitum
with entries in col.C, E & D again ad infinitum?
"Bernard Liengme" wrote in message
...
In the cell type =F67+C68+E68-D68
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Zygy" wrote in message
...
What do I do to have a result appear automatically in F68 which is the
result of F67+C68+E68-D68. Currently I Copy and Paste on F67 & F68.






Bernard Liengme

How to create a formula?
 
Click on the first cell with the formula
Note the small solid square in the lower tight corner - it's called the
'fill handle
Position the mouse cursor over this - the cursor changes from a large open +
to a small solid + when you are in position
Drag the fill handle down the column
OR, if the column next to the one of interest is full of entries then double
click the fill handle to do an automatic fill to the bottom
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Zygy" wrote in message
...
As I said I copy and paste the formula already, but how do I create a
formula that would produce the result in F69,70,71, ect, ect ad infinitum
with entries in col.C, E & D again ad infinitum?
"Bernard Liengme" wrote in message
...
In the cell type =F67+C68+E68-D68
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Zygy" wrote in message
...
What do I do to have a result appear automatically in F68 which is the
result of F67+C68+E68-D68. Currently I Copy and Paste on F67 & F68.









All times are GMT +1. The time now is 05:58 AM.

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