Percentage forumlae!?

N

Neo1

Hello, I have a slight problem which shouldnt be too hard to solve:

I want to multiply a percentage by a number but first if for example i
have in A1 50 and then in B1 10% i want C1 to display 10% increase of
50, but how do i do this without typing in 50 * 1.1.....? is there some
other way


Thanks
From John
 
P

Pete_UK

Enter a formula in C1 by typing:

= A1 * (1 + B1)

When you press <enter> you will see the result. You can change the
percentage in B1, or you can change the number in A1 and the value in
C1 will automatically change. If you have several values in column A
and percentages in column B you can copy the formula down column C and
the references to the cells will automatically change.

Hope this helps.

Pete
 
Top