How to compare 2 columns with number

[Anonymous]

Hello guys,

I would like to ask you for help.

I have two columns A(last measurement) and B(previous measurement) with numbers 0-5. I need to compare numbers in column A with column B and make condition to add results to new columns C(trend).

3 Conditions:

- if number in column A is less then number in Column B then add number 1 to columns C

- if number in column A is equal to number in Column B then add number 2 to columns C

- if number in column A is bigger then number in Column B then add number 3 to columns C

Then I will use this new Column C and create conditional formating with 3 arrow icons for showing if last measurement is bigger, equal to or less then previous measurement.

Maybe my solution is wrong or too complicated.

Thank you for help

[Anonymous · Accepted solution]

Hello guys,

sorry for last reply, I solved this task with

column C =
if column A < column B, 1,
if column A = column B, 2,
if column A > column B, 3
)

Thank you all so much you tried help me.

[Samarth_18]

Hi @Anonymous ,

You can use below code:-

column C =
SWITCH (
    TRUE (),
    column A < column B, 1,
    column A = column B, 2,
    column A > column B, 3
)

Thanks,

Samarth

[mh2587]

You need a switch() function to give multiple condition