View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
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).