| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up autosum as a %
=(B2/A2-1)*100
B2 has this year A2 was last year You can format the cell as a %, the formula would then be =B2/A2-1 -- Greetings from New Zealand "Robert s" <Robert wrote in message ... Trying to set up figures from one year to next and would like to show difference as a % |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I set up a shortcut key for Autosum? | Excel Worksheet Functions | |||
| How can I autosum only visible cells? | Excel Discussion (Misc queries) | |||
| Autosum | Excel Discussion (Misc queries) | |||
| autosum ?? | Excel Worksheet Functions | |||
| autosum problems | Excel Worksheet Functions | |||
Hybrid Mode
