Hi,

A1= percentage
B1= Base number
Try this formula
=B1+B1*A1
Format as number

Mike

"Southern Kiwi" wrote:

I am wanting to do this:

Cell A contains a percentage, sometimes negative, sometimes positive.
(cell A by necessity is formatted as a percentage)

Cell B contains the "base figure" which I want to apply that % to.

Cell 3 is to contain the answer.


If cell A is positive I want that percentage added to cell B, if it's
negative I want it subtracted.

Thanks for any help