ExcelBanter - Apply a percentage factor to a base number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Apply a percentage factor to a base number (https://www.excelbanter.com/excel-worksheet-functions/196719-re-apply-percentage-factor-base-number.html)

Gary''s Student

Apply a percentage factor to a base number

=B1*(1+A1)
--
Gary''s Student - gsnu2007j

Southern Kiwi

Apply a percentage factor to a base number

Gary''s Student wrote:
=B1*(1+A1)

Gee that seems so simple compared to what I have been trying to do
(using if statements to differentiate between positive & negative)
Thanks for the help, I'll feedback tonight

All times are GMT +1. The time now is 07:47 PM.