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

[KARLOSS/QUEENS]

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

 

[Ragdyer]

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