| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting 3% from a work sheet
Hi,
I have had one of those days, i would like to know how to simply get a 3 percent figure from a box with a add sum formula and place it in a box else where on the sheet i bet its something that can be done whilst sleeping but its getting me big time. Michael |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting 3% from a work sheet
Multiply the cell by 0.03
A1 = 100 =A1*0.03 -- Biff Microsoft Excel MVP "Michael Higgins" wrote in message .uk... Hi, I have had one of those days, i would like to know how to simply get a 3 percent figure from a box with a add sum formula and place it in a box else where on the sheet i bet its something that can be done whilst sleeping but its getting me big time. Michael |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting 3% from a work sheet
If your sum formula is in A1 and you want 3% of that sum in B1, put this
formula in B1: =A1*3% Tyro "Michael Higgins" wrote in message .uk... Hi, I have had one of those days, i would like to know how to simply get a 3 percent figure from a box with a add sum formula and place it in a box else where on the sheet i bet its something that can be done whilst sleeping but its getting me big time. Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
| Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Linear Mode
