Forum Discussion
Rick Carter
Apr 21, 2018Copper Contributor
Formulas without cell references
Hi all.
My boss asked me to help him with management's financials spreadsheet yesterday, and while helping him I noticed many cells with contents like this:
=(1372440)-(648299+487275)*4
I assumed that whoever made this sheet did not orginally type such formulas, it looks to me like some kind of copy and paste where values but not cell references are pasted, but the arithmetic is still shown in full.
How is this done, or how does it result?
1 Reply
- Logaraj SekarSteel Contributor
Hi,
Some one has used Paste Values function with Operations (or else) calculated using direct values.
That's all.