Show an original amount plus % increase in same cell.

**rosebud28805** · 01-14-2011, 12:55 PM

Hi,

I know this must be simple, but I still need help nonetheless. How do I do the following in excel? Take the amount of $3,500 and increase it by 1.8% which is $63.00 I think. But then show the increased amount of $3,563 within that same cell?

Thanks in advance!

**ChemistB** · 01-14-2011, 01:04 PM

Not so simple.

You cannot have an input value and a formula (calculation) within the same cell. This will require VBA to accomplish. Is this going to occur within a single cell (i.e. always A2) or down a column?

OR, you could do what shg suggested below.

**shg** · 01-14-2011, 01:07 PM

Enter 1.018 in a cell, copy, select the cells of interest, and do Edit > Paste Special, tick Multiply and Values.

**rosebud28805** · 01-14-2011, 01:54 PM

Originally Posted by ChemistB

Not so simple.

You cannot have an input value and a formula (calculation) within the same cell. This will require VBA to accomplish. Is this going to occur within a single cell (i.e. always A2) or down a column?

OR, you could do what shg suggested below.

Thanks for letting me know that I cannot do this within the same cell. This will go down a column. What shg suggested works perfectly. Thanks to both of you!