formula copies value from original cell only

S

smaem

Trying to copy a simple formula (=e2*3) to the next cell. If the cell I am
copying equals 5, the value is posted to cell to which I ma copying and not
the appropriate result.
 
T

tim m

Not sure if I understand do you want the formula to be copied to the next
cell or the actual result of the formula (that being 5)?

If you want to copy and paste the result use copy....paste special.....values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Excel Need Countifs Formula Help 0
Select a range not equal to: 4
Return of value when copying a formula 4
Excel VBA 1
Copying formulas across columns 2
Exel 2003 Copy Formula Problem 4
Formula for advance worksheet name to next worksheet name 2

Top