Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Need to figure out a percentage

The reason you are having problems is that you are zero-based. There is an
easy fix. Let's say you estimate expenses (including profit) of $50,000 and
income of $50,000. Your estimated net is $0.00, but you actually have income
of $51,000.

Your percentage should be 1000/50000 or 2%
--
Gary's Student


" wrote:

I need an equation to figure out: We budget $0 (or breakeven) and
actually make / or lose say $1000. I can't figure out how to get a
percentage for this, whether it's positive or minus.

Could anyone help?


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
FORMAT PERCENTAGE IN INDEX CELL? Ladybug726 New Users to Excel 1 November 20th 05 05:09 AM
Percentage difference calc that knows the largest figure Mighty Magpie Excel Discussion (Misc queries) 3 November 10th 05 06:45 PM
Formatting percentage signs in Excel Romany Excel Discussion (Misc queries) 3 June 1st 05 07:02 PM
percentage of production against quotation Nigel Excel Discussion (Misc queries) 3 April 22nd 05 02:34 PM
percentage of sales Kay LJ Excel Worksheet Functions 2 January 11th 05 01:38 AM


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