Try this in C14:

=-C13*0.2

and this in C15:

=C13 + C14

Hope this helps.

Pete

On Apr 14, 6:06*pm, Randall wrote:
Hi can some one help me out .
*I have a work book and i need to show some % and balances .
In C13 i have a total in C14 i need to show 20% of that total ie -20% and in
C15 the balance after the 20% has been tacken away .
*I hop that some one can help me .
* * Randall.