Percentage, the other half

  • Thread starter Thread starter Steve L.
  • Start date Start date
S

Steve L.

Hi all,
I'm working on a spreadsheet and I need to show how much of a certian
percent is left in a dynamic cell.
Say I have $1000 that is the total bid price of a job and $670 is the
current raw cost of the job. OK I can figure out what percentage $670 is of
$1000 (67% duh). What we want to show is the margain, in other words the
difference between the 67% and 100%. I can make it work by subtracting 100%
but I get a negative number. Do you guys know what I'm talking about?
=IF(C14=0,0,D14/C14)-100%
 
If the bid price is in A1 and the raw cost is in A2, then the margin is

= 1 - A2/A1

formatted as a percentage.
 
Frank Kabel said:
=IF(C14=0,0,1-(D14/C14))
Click to expand...

Since x/0 is undefined, you might also consider

=IF(C14=0,"",1-D14/C14)

so that the result isn't confused with the case when D14 = C14.
 
Since x/0 is undefined, you might also consider

=IF(C14=0,"",1-D14/C14)

so that the result isn't confused with the case when D14 = C14.
Click to expand...

Great tip!
Thanks again JE.
 
Back
Top