If I'm reading this correctly...

If your reference cell is 4-637999 then set the cell to 1172, otherwise
set to 1162.

The following formula would do that (in this example A1 is the
reference cell)...

=IF(AND(A1=4,A1<=637999),1172,1162)

Hope this is of some use,
Wayne