View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Willing to learn Willing to learn is offline
external usenet poster
 
Posts: 18
Default Total Revenue Percentage

hi joe,
that did not give me percent.

" wrote:

"Willing to learn" wrote:
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
[....]
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


Try this:

B3: =B1-B2

B4: =B3/B1