| 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 |
| 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 | |||
Threaded Mode
