| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentages
I have a spread sheet that breaks down costs of a product by country of
origin. I want to be able to fill in a unit price in one cell and then have that number broken out by set percentages in other cells. How do I do this? Example: a1 = 2144.00 b2 = 25% b3 = 536 c2 = 50% c3 = 1072 d2 = 25% d3 = 536 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
percentages
=B2*A1 in B3
=C2*A1 in C3 =D2*A1 in D3 -- Gary's Student "kthornton" wrote: I have a spread sheet that breaks down costs of a product by country of origin. I want to be able to fill in a unit price in one cell and then have that number broken out by set percentages in other cells. How do I do this? Example: a1 = 2144.00 b2 = 25% b3 = 536 c2 = 50% c3 = 1072 d2 = 25% d3 = 536 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding percentages problem need a solution for | Excel Discussion (Misc queries) | |||
| What format do I use to mail merge percentages? | Excel Discussion (Misc queries) | |||
| copying sheets with percentages | Excel Discussion (Misc queries) | |||
| Custom Format- Negative Percentages | Excel Discussion (Misc queries) | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
Linear Mode
