Excel 2003

[Randall]

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.

 

[Pete_UK]

Try this in C14:

=-C13*0.2

and this in C15:

=C13 + C14

Hope this helps.

Pete