Amateur wrote:

xlmate: I agree, I would have expected the formula to read =Budget!J60*2.
When I click on the cell in the budget worksheet it reads =Budget!J60 but as
soon as I select the savings worksheet it changes to =Savings!J60

Still a mystery.



After clicking on J60, just type "*2" and hit enter. DO NOT reselect the other
worksheet.