IF formula not working properly

[RRuiz]

Hello,

I have a formula I have used on several different data sheets that is not working on this new sheet and I cannot not figure out why.

The following should be returning a 0% as Cell BH2118 dose have a "1" in the form but its acting like the 'IF(BH2118="1","0"' portion is not there.

=IF(I2118="","",IF(BH2118="1","0",SUM(K2118,AB2118)/100))

Any ideas on fixes?

Thank you

 

[Joe4]

Is it a numeric value of 1 or a text value of 1 in BH2118.
If it is numeric, you need to get rid of the double-quotes around the 1, i.e.

[U]=IF(I2118="","",IF(BH2118=1,0,SUM(K2118,AB2118)/100))[/U]

 

[RRuiz]

Oh my, it was numeric and not text. Thank you so much!

 

[Joe4]

You are welcome.

Yes, it make a difference. Everything between double-quotes are treated as Text. So you do not want numeric values between double-quotes.