FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL
 

I AM TRYING TO SET UP A FORMULA ON BREAKDOWN PERCENTAG, EXAMPLE
4550.60 IS THE FU LL AMOUNT , BREAKDOWN 20% TO DIV. ONE, 67% TO DIV2
ETC. HOW DO I SET UP EACH CELL FROM ONE AMOUNT 4550.60

FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL
 

Assign a cell to hold your "full' amount, and have all your formulas
reference that particular cell.

For example, with "full amount" in A1:

Div.1 formula:
=A1*0.2

Div. 2 formula:
=A1*0.67
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KARLOSS/QUEENS" wrote in message
...
I AM TRYING TO SET UP A FORMULA ON BREAKDOWN PERCENTAG, EXAMPLE
4550.60 IS THE FU LL AMOUNT , BREAKDOWN 20% TO DIV. ONE, 67% TO DIV2
ETC. HOW DO I SET UP EACH CELL FROM ONE AMOUNT 4550.60