Add Percentage to a cell value

[lesley burlingham]

I have a cell value in cell B2 which is dirived from an INDEX ad MATCH formula. I have a percentage in cell B3 say 5%. I would like to add the percentage in B3 to the value in B2 and put theanswer into B4.

 

[prasaddn]

Hi,

Will this work for you?

formula in b4:

=B2+(B3*B2)

Regards,
Prasad DN

 

[lesley burlingham]

It i giving Value as the abswer in B4

 

[prasaddn]

So, are you expecting the answer in B4 to be in % format? can you share some example file, please.

 

[lesley burlingham]

See attached. I am trying to add the % in Cell C21 to E17. E17 has a INDEX and MATCH formula.

 

[prasaddn]

With current example on file, pls refer to sheet 1, J16 cell it has 8.597,77 which is "text" and not "number", because of "," in it.

in case you remove comma, it will reduce the decimals to 2 positions and value is changed to 8.60

to retain 8.59777, increase the decimals in formatting.

Once you have this done, the above said formula will work.

Now, you may use find and replace window to change remove all ",".

See attached file, and pls do check for values are correct in sheet 1.

I have just copied your formula and multipled with c21% like

= YourFormula + (c21 * YourFormula)

I also believe there is good scope to simplify your formula and also to include mark up % in price.

Regards,
Prasad DN
PS: Culprit is ","s in sheet1 making all mathematically formula fail.

 

[lesley burlingham]

Thanks for your help