Custome formula

Not sure whether you need all those approaches when it false. Better attach a sample workbook with expected output by describing the method.

Its almost impossible to say what the error might be, without seeing the workbook that it apples to. But if the test is TRUE, it "should" return the text WASTE RAID, unless that is a named range - in which case, you need to remove the ""

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

The criteria in your last post (F cell is < 14200, or tell me NEEDS TO RAID if =>14200) is different to your 1st post ((F210<=9800), and the formula you have in column H (I presume thats the formula in question?) is only...
={TODAY()-OFFSET($I14,-(ROW()-ROW($I$3)),MAX(IF(NOT(ISBLANK($I14:$DZ14)),COLUMN($I14:$DZ14),0))-COLUMN($I14))}
compared to post 1 of
=IF(F210<=9800, "WASTE RAID",TODAY()-OFFSET($I210,-(ROW()-ROW($I$3)),MAX(IF(NOT(ISBLANK($I210:$DZ210)),COLUMN($I210:$DZ210),0))-COLUMN($I210)))

please clarify your request?

In H4 cell

Formula:

Please Login or Register  to view this content.

Drag it down...