New to formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with formulas, or a math function.

Bacically what I need to do is have Cell A2 subtract Cell A1 and be
outputted to Cell B2.

I have no idea how to start this.

Thank You
 
Money 2006 said:
I need help with formulas, or a math function.

Bacically what I need to do is have Cell A2 subtract Cell A1 and be
outputted to Cell B2.

I have no idea how to start this.

Thank You
Click to expand...


In cell B2 type "=A2-A1" (without the quotes)
 
Great, that seems pretty simple.

Is there a simple way to replicate that formula so I could use it without
having to specify the exact Colum/Row?

Meaning I need to do what I originally asked, but need to duplicate that
function, down multiple colums across multiple sheets.
 
Peo said:
Copy the formula by grabbing the lower right corner of the cell and copy it
down
Click to expand...

Peo answered first part on how. Here's how to do it across
multiple sheets:

To do it across multiple sheets group the sheets first then
when you make a change on one sheets it's made on the whole
group. Highlight a sheet tab then hold down the shift key
and select the last sheet all sheets in between will be
highlighted.
If you need to pick and chose sheets use the control key
instead of the shift key. Don't forget to ungroup the sheets
before you start entering values.

gls858
 
Although Peo's suggestion will copy the formula down column "B", I can't see
how this would be of any use.
Can you give more detail of the data in cols "A" & "B" ?

George Gee
 
This if for Fuel Oil Delivery, It's to keep a running total of "Degree Days"
used.

Colum A would have the "Degree day" example 12375, colum B would have to
number of days used since the number above 12345.

12345 00
12375 30
12395 20

That is an example.
 
Back
Top