| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages
Thanks Sheeloo, That worked great.
"Sheeloo" wrote: Enter this in B2 and copy down till B10 =(B2-B$1)/B$1*100 Enter this in C2 and copy down =C1*(1+B2/100) -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "tommy" wrote: Hi, can any one help what I Would like to do is, in column A1 to A10 I put in a series of numbers each bigger than the next, in column B2-B10 I need a calculation that tells me what percentage A2 is greater than A1 and then What percentage A3 is greater than A1 and so on, the in C1 I would put in a number and in C2 a number that is greater than C1 by the percentage in B2 and so on. I hope this makes sense. Thanks in advance. Tommy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentages | New Users to Excel | |||
| percentages | Excel Worksheet Functions | |||
| percentages | Excel Worksheet Functions | |||
| Percentages | Excel Discussion (Misc queries) | |||
| Percentages | Charts and Charting in Excel | |||
Threaded Mode
