Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 52
Default How to find formula for....

What formula do I use to find "% of month's income". I have Net Sales,
Royalty, Manufac. Costs, Advertising, and Net Income (B4-F4).
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default How to find formula for....

If month's income is in A2, and the whatever amount you have is in a1, % of
month's income is:

=a1/a2

Format as percent.

Regards,
Fred.

"Jill" wrote in message
...
What formula do I use to find "% of month's income". I have Net Sales,
Royalty, Manufac. Costs, Advertising, and Net Income (B4-F4).


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
Need to find the right formula Matt Bergum Excel Discussion (Misc queries) 2 December 14th 06 07:55 PM
Need to find a formula Lanza52 Excel Worksheet Functions 1 July 13th 06 06:11 AM
Need Help With A Find Formula toy4x4 Excel Worksheet Functions 3 June 28th 05 11:48 AM
Lookup Formula - but have a formula if it can't find/match a value Stephen Excel Worksheet Functions 11 June 14th 05 05:32 AM
Can you help to find the right formula? Metallo Excel Worksheet Functions 4 November 22nd 04 09:47 AM


All times are GMT +1. The time now is 01:18 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"