excels formuals
 

how to creat a formual that show a increase value of a number if that number
was increase by a precent
what is the basic formual

excels formuals
 

If you have an original value in A1 and a percentage increase in B1
(formatted as percentage), then the increased value =A1*(1+B1)
If B1 contains the percentage as a number (such as 10, rather than 10%),
then the formula is =A1*(1+B1%)
--
David Biddulph

"jvenditti" wrote in message
...
how to creat a formual that show a increase value of a number if that
number
was increase by a precent
what is the basic formual

excels formuals
 

Perhaps a simple example will illustrate it ..
In A2 down are the source numbers, eg: 100, 200, etc
In B2 down are the percentage increases for each source number,
eg: 10%, 15%, ... (note that these are entered with the "%" sign)

You could put in C2: =A2*(1+B2)
and copy C2 down to return the required results
Any good? hit the YES below
--
Max
Singapore
xde
---
"jvenditti" wrote:
how to creat a formual that show a increase value of a number if that number
was increase by a precent
what is the basic formual