Entered Cell value to multiply based on target cell value.

Jingles88

New Member
Joined
Oct 19, 2016
Messages
1
Hi,

I am trying to work out how to multiply certain fields on a spreadsheet based on the value of a target cell. For example:

D2= 56 (however this value will change on a daily basis)
Value entered into D23 is 2, however will automatically change to 112.

I need this to happen in numerous cells.

I am unable to add attachments at the moment, however below is a screen shot of what im working with:



Any help would be much appreciated.

Regards,

John.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,118,404
Messages
5,571,915
Members
412,426
Latest member
DeficientOptimism
Top