Automatically multiply cell

[sjm44]

Hello,

I have a a list of items that need to be multiplied by a cost when data is input.

So for example if I have a cost of £2 for column J, any value that I enter in that column must be multiplied by that cost.

Is there a quicker way to do this than what I already have

=Sheet2!J11*Sheet2!E5

E5 is where the cost for the column is kept. J11 is where I am multiplying what is entered in a different sheet, then showing the cost figure in Sheet 1.

I was wondering if its possible to just format a column so whatever data is entered into it is multiplied by a specified amount from another cell.

Thanks and I hope I have explained it so it is understandable!

 

[niceguy_jay]

you can use this formula

=Sheet2!J11*Sheet2!$E$5

and paste it till the end of J column...tell me if this works...