I want to compare 3 columns in Excel and return 1 or 0 depending on the result.

E.g.

If the value in column A < Column B < Column C, i.e., the value in Column B is between the values in Columns A and C, then return 1, otherwise 0.

E.g.

If the value in column A < Column B < Column C, i.e., the value in Column B is between the values in Columns A and C, then return 1, otherwise 0.