Solved: Absolute Figure

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

shillguy

Thread Starter
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.

Thanks in advance.
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
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
 
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.
 

shillguy

Thread Starter
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top