#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Excel 2003

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to paste Excel 2003 chart into Outlook 2003 Fat Frog Charts and Charting in Excel 0 August 7th 07 05:26 PM
opening excel files from access 2003, win xp, office 2003 Nugimac Excel Discussion (Misc queries) 2 April 26th 07 12:32 PM
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? lewisma9 Excel Discussion (Misc queries) 0 February 27th 07 12:23 AM
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message [email protected] Excel Discussion (Misc queries) 0 July 10th 06 03:07 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"