Copying Calculations

  • Thread starter Thread starter Dave \IT\
  • Start date Start date
D

Dave \IT\

Hey Group,

First of all, I've done some pretty advanced programming within Excel, both
in the spreadsheet and VBA. I may just be missing an obvious, but it's
frustrating me to no end. Here's my problem.

I have a sheet of data. Nothing special, just inputted numbers. All of the
fields are Numerical, and all formatted the same way. I write a formula in
F10 that reads '=C10*E10' and it gives me my result...which is correct. I
then click-n-drag (on the bottom right corner) to copy this equation to the
next 10 cells. They all read correctly ('=C11*E11', '=C12*E12', etc.), yet
the number that appears is the same as the first result. In other words,
the formula is copied properly, but the displaying result isn't.

How can this be?
 
Good afternoon Dave -

Hmmm - wonder if you may have overlook the calculations options?
Check and see if you're set to manual calculations.

If that is not it - maybe you could ZIP or Stuff the file and send it to me to look at.

I cannot think of anythin else right off hand.

Thanks,
Jon Barchenger
--------------------
| **From: "Dave \"IT\"" <[email protected]>
| **Newsgroups: microsoft.public.excel.worksheet.functions
| **Subject: Copying Calculations
| **Lines: 17
| **X-Priority: 3
| **X-MSMail-Priority: Normal
| **X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| **X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| **Message-ID: <[email protected]>
| **Date: Mon, 10 Nov 2003 13:33:53 -0500
| **NNTP-Posting-Host: 207.236.60.69
| **X-Complaints-To: (e-mail address removed)
| **X-Trace: news20.bellglobal.com 1068489235 207.236.60.69 (Mon, 10 Nov 2003 13:33:55 EST)
| **NNTP-Posting-Date: Mon, 10 Nov 2003 13:33:55 EST
| **Organization: Bell Sympatico
| **Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.com!prodigy.com!prodigy.com!in.100proofnews.com!
in.100proofnews.com!snoopy.risq.qc.ca!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
| **Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.worksheet.functions:170335
| **X-Tomcat-NG: microsoft.public.excel.worksheet.functions
| **
| **Hey Group,
| **
| **First of all, I've done some pretty advanced programming within Excel, both
| **in the spreadsheet and VBA. I may just be missing an obvious, but it's
| **frustrating me to no end. Here's my problem.
| **
| **I have a sheet of data. Nothing special, just inputted numbers. All of the
| **fields are Numerical, and all formatted the same way. I write a formula in
| **F10 that reads '=C10*E10' and it gives me my result...which is correct. I
| **then click-n-drag (on the bottom right corner) to copy this equation to the
| **next 10 cells. They all read correctly ('=C11*E11', '=C12*E12', etc.), yet
| **the number that appears is the same as the first result. In other words,
| **the formula is copied properly, but the displaying result isn't.
| **
| **How can this be?
| **
| **
| **
 
Back
Top