Originally Posted by KerriL

Hello Spencer101,

Thank you. I tried your formula in my sheet where I'm having the issue, but it did not work. I tried it in a test sheet where I typed in the cell contents, and it did work. I think the problem is still that the cells which are populated by formulas are somehow not formated correctly. I think it might be that the cells contain the number out to four decimals, but the number the IF statement is searching for only has two. I'm not sure how to fix this--I know I can format it to only show two decimals, and I can use the ROUND formula to round an individual cell to two decimals, but how do I apply this to hundreds of cells? Thank you again for your help.