| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Hi,
I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
Hi
Try this: =(B2-A2)/A2 Andy "grobertson" wrote in message ... Hi, I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
=(B1-A1)/A1 and format as a percentage Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=507689 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
"grobertson" wrote in message ... Hi, I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn Begin by writing down the formula as if you were showing it to a high school student. Show us what you come up with. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
Glenn,
In C1, enter: =(B1-A1)/A1 Ewan "grobertson" wrote: Hi, I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
If you want the result to display as a percentage also format cell C1 as a
percentage. HTH Neil www.nwarwick.co.uk "ewan7279" wrote: Glenn, In C1, enter: =(B1-A1)/A1 Ewan "grobertson" wrote: Hi, I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
Sorry - must format too,
In C1 enter: =(B1-A1)/A1 then format the cell by going to Format=Cells=Percentage "grobertson" wrote: Hi, I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
In cell C1: =b1/a1 - 1. Format as a percentage
"grobertson" wrote: Hi, I have two columns of numbers A B C 1 103,956.09 119,894.84 What I would like is a formula in Cell C1 that will show a percentage increase of cell B1 on A1. Many Thanks Glenn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
Hybrid Mode
