Percentage between two values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: George Inacio (jginacio_at_hotmail.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 03:52:26 +0200

Hello Everyone.

I need to find the Profit percentage using the Cost and Sale.
I use this formula to find the percentage;

Cost = 100
Sale = 110
ProfitPercent = (Sale * 100 / Cost) - 100

Works fine but if the Cost = 0 and Sale= 110 I get in troubles.
I have no idea how to calculate a percentage from Cost=0 with a Sale= 110.

Can you help me please?

Thanks in advance!

Regards,
George

Relevant Pages

  • Re: HP World Magazine: For Business Continuity...the answer may be OpenVMS
    ... I happened to know the approximate cost to manufacture DS15 when it was ... There isn't all that much profit in the sale of these systems. ... The only way to profitably sell Alphas much cheaper would be to cut the ...
    (comp.os.vms)
  • Re: Percentage between two values
    ... if cost is 0 then profit percentage is undefiined if percentage is based on ... This lets you define all the appropritate tests for valid cost and sale ... You could even code the routine to return a known value for your testing, ...
    (microsoft.public.vb.general.discussion)
  • Re: New to all this - need some advice and answers
    ... text normally associated with a for sale post (something like "1976 ... Cost relative to renting? ... can anyone recommend more aircraft for sale web sites? ... As a non-pilot the insurance is essentially for training. ...
    (rec.aviation.owning)
  • Re: Pivot table sum issue
    ... What happens when you try to put both Cost and Sale in the Data area? ... Canada 4 9 ... Foreign 9 21 ...
    (microsoft.public.excel.misc)
  • Re: Fabric Club membership?
    ... I think that they have reduced the cost of the plan which is ... Last time I was in the store ... visit - I had some fabric which was sale priced while the notions were ... Cynthia even sent me a pack of 8 half yard cuts one month of fabrics ...
    (rec.crafts.textiles.quilting)