ok I have a formula that's causing issues

=IF(F210<=9800, "WASTE RAID",TODAY()-OFFSET($I210,-(ROW()-ROW($I$3)),MAX(IF(NOT(ISBLANK($I210:$DZ210)),COLUMN($I210:$DZ210),0))-COLUMN($I210)))

it seems to not want to write out a muber when the formula is ture.. if its true it gives me an #VALUE! error

any ideas..i can post the workbook if needed please ask