Mudcat Café Message Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafeawe

User Name Thread Name Subject Posted
GUEST,Dazbo at Work BS: pasting formula in MS Excel (9) BS: pasting formula in MS Excel 02 Jun 08

A problem I've just encountered in excel.

In A1 I have a constant, in this case 440.

I write a formula in A2 [A1*1.05] which Excel displays as 462.

I copy this formula and paste into A3. The formula bar shows the formula as A2*1.05 but the cell shows 462. I've not used special paste commands so it's not pasting in the value from A2.

I subsequently paste this formula down column A but each cell displays 462.

If I rewrite the formula into A3 Excel displays the correct answer.

I'm totally baffled, any idea what's going on?

(I've discovered the evaluate formula tool and it shows the correct formual, picks the value in A2 but the evaluate step displays it as if the value only is pasted).

Post to this Thread -

Back to the Main Forum Page

By clicking on the User Name, you will requery the forum for that user. You will see everything that he or she has posted with that Mudcat name.

By clicking on the Thread Name, you will be sent to the Forum on that thread as if you selected it from the main Mudcat Forum page.

By clicking on the Subject, you will also go to the thread as if you selected it from the original Forum page, but also go directly to that particular message.

By clicking on the Date (Posted), you will dig out every message posted that day.

Try it all, you will see.