You have two separate conditions here. The first (OR statements, which could be condensed to =IF(OR(H7=2000,I7=2000,J7=2000),0,F7)) has zero as the true value and F7 as the false value. The second formula has this switched, with F7 as the true value, and zero as the false.
You could try something like this:
=IF(L7="Smith",F7,IF(OR(H7=2000,I7=2000,J7=2000),0,F7))
but if the first statement is returned false, and the second as well, this could produce an error since the first statement should have returned zero instead of F7.
Bookmarks