# Solved: Absolute Figure

Discussion in 'Business Applications' started by shillguy, Jan 19, 2011.

Not open for further replies.

Joined:
Mar 31, 2009
Messages:
26
C2D / 2 GB / Win 7 / Excel 2007
For example if cell A1 is 2 and A2 is 4, then in A3 their multiplication will show as 8. Now, what I would like is that cell A3 becomes the absolute number, and not a result. i.e not A1*A2 but should be read as 8, and that in case I delete A1 & A2, then still the result of 8 is displayed.

I would like to use the data which is the result of a function to become the final figure.

Joined:
Mar 27, 2008
Messages:
6,596
First Name:
Hans
You can copy and paste special as value for these cells after the calculations, else you'll have to use a macro that does the calculation for you

BTW Absolute is a mathematical term and not what your question implies

3. ### Bpierson

Joined:
Jan 15, 2011
Messages:
3
Highlight the entire Row A3 and select copy. Keeping RowA3 highlighted, select to paste, special, values. Then you can delete Rows 1 & 2.

Joined:
Mar 31, 2009
Messages:
26
Thanks a ton guys!!
Keebellah & Bpierson you both have solved quite a dilemma I have been facing for quite some time.

As Seen On