[Solved] Formula to use for multiplication

[cobra_fd]

Someone out there can probably solve this in a second, but I could not find what I was looking for.

I am trying to find the function required to return a value into a cell after a multiplication.

Example is I have a known value of 294pcs per unit and when I do inventory, I want to input the number of units in the cell and have the formula perform the mutiplication calculation and replace the input number and display the sum.

This is probably something from on "Are you smarter then a fifth grader"?

Thanks in advance.

[therabi]

Someone out there can probably solve this in a second, but I could not find what I was looking for.

I am trying to find the function required to return a value into a cell after a multiplication.

Example is I have a known value of 294pcs per unit and when I do inventory, I want to input the number of units in the cell and have the formula perform the mutiplication calculation and replace the input number and display the sum.

This is probably something from on "Are you smarter then a fifth grader"?

Thanks in advance.

It is not something that can be done, with a formula. A formula places the result in the cell it is in.

Hope This Helps.

[RoryOF]

You need to use another column to hold the result. Your structure should be like this

Code: Select all

       cost    inventory     value
        A         B                C
1     12.34     987        =A1*B1

[cobra_fd]

Thanks roryOF, that's what I thought was going to the simplest solution, was trying to keep the columns to a minimum to have the most information on a printable page.

[Villeroy]

Enter in B1:
=A1*987
hit F9, Enter, Enter