Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

New to formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Money 2006 - 19 Jul 2007 18:50 GMT
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
Gordon - 19 Jul 2007 18:54 GMT
>I need help with formulas, or a math function.
>
[quoted text clipped - 4 lines]
>
> Thank You

In cell B2 type "=A2-A1" (without the quotes)
Money 2006 - 19 Jul 2007 20:08 GMT
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.

> >I need help with formulas, or a math function.
> >
[quoted text clipped - 6 lines]
>
> In cell B2 type "=A2-A1" (without the quotes)
Peo Sjoblom - 19 Jul 2007 20:10 GMT
Copy the formula by grabbing the lower right corner of the cell and copy it
down

Signature

Regards,

Peo Sjoblom

> Great, that seems pretty simple.
>
[quoted text clipped - 14 lines]
>>
>> In cell B2 type "=A2-A1" (without the quotes)
gls858 - 19 Jul 2007 20:34 GMT
> Copy the formula by grabbing the lower right corner of the cell and copy it
> down

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
George Gee - 19 Jul 2007 20:38 GMT
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

> Great, that seems pretty simple.
>
[quoted text clipped - 14 lines]
>>
>> In cell B2 type "=A2-A1" (without the quotes)
Money 2006 - 20 Jul 2007 20:48 GMT
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.

> Although Peo's suggestion will copy the formula down column "B", I can't see
> how this would be of any use.
[quoted text clipped - 20 lines]
> >>
> >> In cell B2 type "=A2-A1" (without the quotes)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.