Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i know this is simple, but driving me nuts - formula
I have 2 cells A1 and A2 with number 2 in each, in A3 i sum (a1*A2),
works great i want to copy the formula to B3, and want excel to use B1 and B2... when i paste it puts in the formula from A3 with the value of (A1*A2), if I db click on the pasted formula, it fixes itself... how do i get this to do this automatically.. (it works fine on a blank worksheet), but not on this existing worksheet thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i know this is simple, but driving me nuts - formula
B3 must be formatted as text. Change it to Comma or general, then past the
formula Also, it may be that A3 is formatted as text and when you copy/paste you are bringing the Text formatting along, so make sure A3 is something other than text " wrote: I have 2 cells A1 and A2 with number 2 in each, in A3 i sum (a1*A2), works great i want to copy the formula to B3, and want excel to use B1 and B2... when i paste it puts in the formula from A3 with the value of (A1*A2), if I db click on the pasted formula, it fixes itself... how do i get this to do this automatically.. (it works fine on a blank worksheet), but not on this existing worksheet thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i know this is simple, but driving me nuts - formula
If no joy with this, check your calculation mode at ToolsOptionsCalculation.
Set to automatic. Gord Dibben MS Excel MVP On Tue, 2 May 2006 10:06:01 -0700, Duke Carey wrote: B3 must be formatted as text. Change it to Comma or general, then past the formula Also, it may be that A3 is formatted as text and when you copy/paste you are bringing the Text formatting along, so make sure A3 is something other than text " wrote: I have 2 cells A1 and A2 with number 2 in each, in A3 i sum (a1*A2), works great i want to copy the formula to B3, and want excel to use B1 and B2... when i paste it puts in the formula from A3 with the value of (A1*A2), if I db click on the pasted formula, it fixes itself... how do i get this to do this automatically.. (it works fine on a blank worksheet), but not on this existing worksheet thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When inserting a simple "Sum" formula all I get is the formula. | Charts and Charting in Excel | |||
Formula is driving me crazy????? | Excel Worksheet Functions | |||
Need help with a simple formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions |