Issue checking to see if cell is 0?

[Tap13]

I have 5 columns: Cost, Commission, Discount Percent, Amount Paid, Amount Saved. The first 3 listed are literal values, the last two are formulas. I want my Amount Paid to come from an if statement that checks if discount percent was 0 then they paid full price, but if discount percent was not 0 then they paid Cost - (Cost*Discount). The formula compares 0% in the discount column against "0" and will not ever say that they are the same (this also goes if I compare discount cell against "0%". What am I doing wrong?

Excel Workbook
	F	G	H	I	J
1	Cost	Commission	Discount Percent	Amount Paid	Amount Saved
2	$ 85.00	$ 28.05	0%	$ -	$ 85.00
2010 Treatment Data

 

[Ron Coderre]

If
F2: 100
H2: 10%
I2 would be 10% off of 100...or 90
and
J2 would be a savings of 10

It seems like these formulas would work for you:

I2: =F2*(1-H2)
J2: =+F2-I2

Does that help? or am I missing something?

 

[jasonb75]

Does correcting your formula do what you need?

=IF(H2=0,F2,F2*H2)

=IF(H2=0,0,(F2-(F2*H2)))

0 is a number "0" is text.

 

[Tap13]

Does correcting your formula do what you need?

=IF(H2=0,F2,F2*H2)

=IF(H2=0,0,(F2-(F2*H2)))

0 is a number "0" is text.

That is what I was doing wrong, I didn't realize quotes made it compare for text and not a number. Getting rid of the quotes made everything work perfectly. Thank you for your guys help.