| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I total only a % of a number (cell) base on total of all cel
I have a set of number and only want to total a part of each cell. Similar
to your taxes when the amount you can count is based on the grand total. I have 17 different categories (cells) and only want to count 5.8% of each catergory as a maxium amount base on the grand total. Ex: It the grand total is 100 and one cell equals 30 then it would only count as 5.8 points. if another cell equaled 3 then it would only equal 3 when added with the 5.8 I hope I have explained this in a way that someone can please help. I am working on a project for a school contest scoring and need some help. Thanks, Douglas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
