What's wrong with this IF statement formula?

Thanks all. attached is the spreadsheet:

(1) I need to fix the formula
(2) I want to define all call ranges and references with names. I know i can define ranges but i can also define names for cell references to make formulas in complex sheets easier to read? (this is related to my last recent post as well)

Thank you very much!