Adding a percentage to a column

[Nahedeh]

Hey everyone! I'm new and this is my first thread and I really need some help asap with Excel as I'm writing a financial report.

Say my two columns look like this:


A B
1 23
2 24
3 25

I want the value of the numbers in column B to be: 20% multiplied by the value in column A and then added to value A. For example 23 x 0.2 = 4.6; 4.6 + 23 = 27.6

Is there a formula for this? How do I do this?

Thanks people; any help would be appreciated!

[Fermented Reptile]

Hi there,

I think =A1+(A1*0.2) will do it.

HTH,

FermentedR

[Nahedeh]

Thank YOU! I also just figured out another way of doing it...

=(A1/100)*120

Thanks again xx