In Sheets, with prov in B and amount in D, type the row-2 formula that flags an Ontario order over $400 with 1 and everything else with 0.

Answer

=IF(AND(B2="ON", D2>400), 1, 0)

AND is a function inside IF's condition slot. Three rows get 1 — orders 1001, 1003, 1006.