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
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