Multiplication formula needed for numbers

Question

Level 1

4 points

Multiplication formula needed for numbers

Hope someone can help. The below sheet has drop down menus that when an item is chosen populates that row with figures EXCEPT Column C which has no formula attached to it.

Could someone provide a formula for Column C so that when I enter a value into it, the individual figures in Columns D, E, F and G will all automatically multiply by this number? I only want the formula to work from row 7 downwards though.

Hope someone can help with this!

Thanks in advance

MacBook Pro 13″, macOS 10.15

Posted on Oct 21, 2020 7:20 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

36,128 points

Oct 21, 2020 7:30 AM in response to ladherts

You would add the multiplication to the formulas in D through G.

For example, in D7, you would have something like:

=IF($C7="","",<your existing formula in D7 goes here>*$C7).

The IF checks to make sure the value in C7 is not blank so you don't get an error warning triangle..

Substitute ; for , in the formula if your region uses , as a decimal separator.

SG

Reply

Answer 2

ladherts Author

Level 1

4 points

Oct 21, 2020 7:38 AM in response to ladherts

Hi,

columns D-G already have a formula attached to them though? this formula populates the cells in these columns with figures when an item in the drop down menu (column A) is chosen. I was under the understanding that cells cant hold more than one formula?

Any way around this?

Reply