Automating Excel calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-3457902%22%20slang%3D%22en-US%22%3EAutomating%20Excel%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457902%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20spreadsheet%20where%20I%20want%20to%20take%20the%20value%20of%20one%20cell%20and%20multiply%20it%20by%20whatever%20value%20I%20enter%20into%20the%20next%20cell%2C%20but%20I%20dont%20want%20to%20have%20three%20cells%20at%20the%20end%20of%20this%20process.%20Let%20me%20explain.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20dont%20want%20to%20take%20A2%20and%20multiply%20by%20B2%20and%20populate%20the%20answer%20in%20C2.%20I%20want%20to%20enter%20a%20value%20in%20B2%20that%20B2%20will%20automatically%20multiply%20by%20A2%20and%20populate%20with%20the%20product%20(not%20the%20value%20I%20entered).%20Basically%2C%20I%20want%20to%20eliminate%20the%20need%20for%20an%20extra%20column.%20Is%20this%20possible%3F%20Will%20this%20require%20VBA%3F%20If%20so%2C%20how%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3457902%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3458853%22%20slang%3D%22en-US%22%3ERe%3A%20Automating%20Excel%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3458853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1410789%22%20target%3D%22_blank%22%3E%40Karen_Ventura%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20would%20not%20recommend%20that.%20It%20makes%20it%20impossible%20to%20correct%20mistakes.%20Using%20a%20third%20cell%20with%20a%20formula%20is%20much%20more%20reliable.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.