How Do I?

  • Thread starter Thread starter Sally
  • Start date Start date
S

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.
 
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))
 
Missed that but either range * percent + range would also work or
range * 1 + percent as you pointed out.
 
Back
Top