Forum Discussion

Rick Carter's avatar
Rick Carter
Copper Contributor
Apr 21, 2018

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 Sekar's avatar
    Logaraj Sekar
    Steel Contributor

    Hi,

     

    Some one has used Paste Values function with Operations (or else) calculated using direct values.

     

    That's all.