Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formuals | Excel Discussion (Misc queries) | |||
New to Formuals | Excel Worksheet Functions | |||
formuals in comments in excel | Excel Discussion (Misc queries) | |||
Many Excels To one | Excel Worksheet Functions | |||
Excels 97 sr-2 where? | Excel Discussion (Misc queries) |