| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autosum of various cells
Hi
I have the following cells D1 = GRAND TOTAL (including E1, F1 and G1 amounts) E1 = 10% of D1 F1 = 7% of D1 G1 = 5% of D1 When I put a figure into D1 I want to autopopulate E1, F1 and G1, but at the moment it is doing the percentages on top of the total in D1. These percentages help make up the D1 total. Can anyone help -- Dorsie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bizarre Excel 03 Problem - autosum not updating when cells are cha | Excel Worksheet Functions | |||
| How can I autosum only visible cells? | Excel Discussion (Misc queries) | |||
| Autosum returns an incorrect zero value on the selected cells | Excel Worksheet Functions | |||
| I cannot extend cells using Shift+arrow keys; I cannot Autosum | Excel Worksheet Functions | |||
| How do I "turn off" cells so they are not included in autosum | Excel Worksheet Functions | |||
Threaded Mode
