Automating Excel calculation

Occasional Visitor

I am creating a spreadsheet where I want to take the value of one cell and multiply it by whatever value I enter into the next cell, but I dont want to have three cells at the end of this process. Let me explain.

 

I dont want to take A2 and multiply by B2 and populate the answer in C2. I want to enter a value in B2 that B2 will automatically multiply by A2 and populate with the product (not the value I entered). Basically, I want to eliminate the need for an extra column. Is this possible? Will this require VBA? If so, how? 

 

Thanks in advance!

1 Reply

@Karen_Ventura 

I would not recommend that. It makes it impossible to correct mistakes. Using a third cell with a formula is much more reliable.