Hi,
i've created this formula which highlights any cell with a value of more than 0.5:
=IF(IF(ISERROR((X48-W48)/W48),"n/a",(X48-W48)/W48)>0.5,"SEE ME","OK")
it works fine but the problem is that i also want to flag up those cells that are less than 0.5... I'm guessing it needs an AND somewhere but can't suss it out - any ideas?
By the way i need to keep the ISERROR bit in the formula coz there are some blank cells knocking about...
Thanks
i've created this formula which highlights any cell with a value of more than 0.5:
=IF(IF(ISERROR((X48-W48)/W48),"n/a",(X48-W48)/W48)>0.5,"SEE ME","OK")
it works fine but the problem is that i also want to flag up those cells that are less than 0.5... I'm guessing it needs an AND somewhere but can't suss it out - any ideas?
By the way i need to keep the ISERROR bit in the formula coz there are some blank cells knocking about...
Thanks