How Do I?

[Sally]

I have a column of numbers that I want to multiply all
those numbers by a certain figure. Can this be done.

I currently have 3 columns #1 is a list price, #2 is a
discount multiplier #3 is our price. The formula I now
have for column #3 reads =if(isblank(E3,"",D3*E3).

What if anything can I do to this formula to have 20%
added to the figure in column #3. I tried =if(isblank
(E3,""(D3*E3)*20%) but that didn't work.

 

[Ken Wright]

With your multiplier in F1, you can use the following:-

=IF(D3="","",D3*E3*$F$1) and copy down.

Note though, in this cae the multiplier would have to be 120%. If you just wanted to put 20% into
the cell, then amend to the following:-

=IF(D3="","",D3*E3*(1+$F$1))

 

[Thomas]

Using your example
IF(ISBLANK(E3),"",(D3*E3)*0.2)
should work

 

[Thomas]

Missed that but either range * percent + range would also work or
range * 1 + percent as you pointed out.