Hi,
I have the following formula to find values between certain criteria.
When the formula looks in the cell which contains the text 'No Data' it gives 'A' as the answer. The cell in question already has a formula in which returns either a % value or 'No Data' based on what the values are in another cell.
Original formula with 'No Data' in the cell but this returns 'A':
=IF(I5>15%,"A",IF(AND(I5>8%,I5<=15%),"B",IF(AND(I5>4%,I5<=8%),"C",IF(AND(I5>0%,I5<=4%),"D",IF(I5<0%,"X",IF(I5="No Data",""))))))
I have altered the formula to use 'ISSBLANK' but this also returns 'A'
=IF(I5>15%,"A",IF(AND(I5>8%,I5<=15%),"B",IF(AND(I5>4%,I5<=8%),"C",IF(AND(I5>0%,I5<=4%),"D",IF(I5<0%,"X",IF(ISBLANK(I5)=TRUE,""))))))
Any ideas?
Terry
Bookmarks