Excel spreadsheet

R

rbane

I hope someone can help me with this problem.


Assume I have a row of cells named B1 and B2.
Today I want the value in B1 to be the product of A1 times A2.
Tomorrow, I will create another row of cells named C1 and C2. I will change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.
I do not want the old value in B1 to change from what it is today.
Can you help me with this?

Thank you very much,

Ron
 

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

VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
If, Or, and 5
FP2003 shows wrong char when load pages 0
Data Validation and drop-down list using IF, AND and what else? 8
Can a formula do this? 1
What is this called in Excel or how it works? 0
Need to have data in one column 1

Top