LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Total Revenue Percentage

Hi, I need help please,

I have the following data:
A B
Month's Net Income $
Month's Total Expense 00
Total Revenue $
Percent Revenue

I would like to have my Percent Revenue % (B4) as result of my Income and
Expense. Also, I would like to have the percent (B4) showing negative percent
result as need it.

For instance, lets make a example, if I earn 50 dollars in my Income (B1) ,
but I spent 100 in (B2) I would like Percent Revenue (B4) show me -100%
otherwise, if I earn 100 and spent 50 it would show me %50

Please help me

Would anyone guide me please.



 
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
Percentage Discount Total mdj101 Excel Discussion (Misc queries) 1 May 18th 06 04:33 PM
Percentage Discount Total mdj101 Excel Discussion (Misc queries) 2 May 18th 06 04:20 PM
Adding percentage as interest to a total Cath Excel Worksheet Functions 3 April 15th 06 01:03 PM
How do i calculate the total revenue in Excel? wondering Excel Worksheet Functions 1 April 13th 06 07:35 PM
a number as a percentage out of a total solskinn Excel Worksheet Functions 3 December 8th 04 06:23 PM


All times are GMT +1. The time now is 03:44 PM.

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

About Us

"It's about Microsoft Excel"