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
