excel
 

Hi I amm doing raw material sheet where you need to add a cell and subtract a
cell and divide at time as well Can you help me so I dont have to format
every colum

excel
 

Believe what you're after are formulas to calculate & return results,
nothing to do with format. Formatting is just for display, it doesn't affect
the underlying cell values.

For better answers, you need to elaborate:
what you have (your sheet set-up),
what you want to do (the required calculations)
how you want to fill the formula (down?, across?, etc)

A simple example:

In A2 down are numbers such as: 10, 20, etc
In B2 down are other numbers such as: 1, 2, etc to be subtracted from col A
In C2 down are other numbers such as: 2, 4, etc to be added to the result

Then you could have something like this in D2:
=A2-B2+C2
and you could copy the formula in D2 down by simply dragging its fill handle
(that's the solid black square at the bottom right corner of D2) so that
it'll calculate/return in the same manner for the values in row3, row4, etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Robyn" wrote in message
...
Hi I amm doing raw material sheet where you need to add a cell and
subtract a
cell and divide at time as well Can you help me so I dont have to format
every colum

excel
 

Its more like
cell is sum=c21-c25/6+d21-d25/6 at this stage I am formulating it right up
to az

"Max" wrote:

Believe what you're after are formulas to calculate & return results,
nothing to do with format. Formatting is just for display, it doesn't affect
the underlying cell values.

For better answers, you need to elaborate:
what you have (your sheet set-up),
what you want to do (the required calculations)
how you want to fill the formula (down?, across?, etc)

A simple example:

In A2 down are numbers such as: 10, 20, etc
In B2 down are other numbers such as: 1, 2, etc to be subtracted from col A
In C2 down are other numbers such as: 2, 4, etc to be added to the result

Then you could have something like this in D2:
=A2-B2+C2
and you could copy the formula in D2 down by simply dragging its fill handle
(that's the solid black square at the bottom right corner of D2) so that
it'll calculate/return in the same manner for the values in row3, row4, etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Robyn" wrote in message
...
Hi I amm doing raw material sheet where you need to add a cell and
subtract a
cell and divide at time as well Can you help me so I dont have to format
every colum

excel
 

Think this expression would do it here, for cols C to AZ
Placed in say C28:
=SUM(C21:AZ21)-SUM(C25:AZ25)/6

(I used a little algebra, grouping the cells in the same row to be summed
together, etc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Robyn" wrote:
Its more like
cell is sum=c21-c25/6+d21-d25/6 at this stage I am formulating it right up
to az

excel
 

Hey Max thanks for that I have it working now

"Max" wrote:

Think this expression would do it here, for cols C to AZ
Placed in say C28:
=SUM(C21:AZ21)-SUM(C25:AZ25)/6

(I used a little algebra, grouping the cells in the same row to be summed
together, etc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Robyn" wrote:
Its more like
cell is sum=c21-c25/6+d21-d25/6 at this stage I am formulating it right up
to az

excel
 

Welcome, glad you got it up!
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Robyn" wrote in message
...
Hey Max thanks for that I have it working now