| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
want a formula give total quanitity break up frm other sheet
I want a formula in excel by which if I put any quantity in cell it will give
its break down which is linked from any other sheet for e.g total qty 30 Break up 6+6+6+6+6=30 when I type 30 it will give me its distribution from any other linked sheet. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
want a formula give total quanitity break up frm other sheet
Why is the breakdown as shown and not (for example) 10+10+10 or 5+5+5+5+5+5?
"Aristotle" wrote: I want a formula in excel by which if I put any quantity in cell it will give its break down which is linked from any other sheet for e.g total qty 30 Break up 6+6+6+6+6=30 when I type 30 it will give me its distribution from any other linked sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| Copy sheet - Break Links to Old Workbook - Retain Formula. | Setting up and Configuration of Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
