At the first look, i noticed that your formula starts with:
=IF(F3="Red Tagged";"Red Tagged";IF(O.......
and in cell F3 you have the value Red Tagged.
in IF evaluations, the formula STOPS at the first TRUE evaluation, so the rest of your formula is not taken into consideration. Take care of the evaluation order, place them in the order you need.
You can use And or OR to this step: IF(AND(F3="Red Tagged";I3="NA");"Red Tagged";IF(O.......
Other error: in the formula , you use different evaluation for the same cell I3: "N/A" and "NA"... maybe it is easier to use only 1 rule for entering data...
if you let users enter data as they wish, you will get : N;A for a change, and your formula will not work..
OR(I3="N/A";$D$1<IF(I3="NA";0;I3)
IF(I3="NA";0;I3)