Swap Values if First Value is Greater than the Second value

I have a sheet where values look like:

6 x 4 = 24 6 x 5 = 30 6 x 6 = 36
7 x 4 = 28 7 x 5 = 35 7 x 6 = 42
8 x 4 = 32 8 x 5 = 40 8 x 6 = 48
9 x 4 = 36 9 x 5 = 45 9 x 6 = 54
10 x 4 = 40 10 x 5 = 50 10 x 6 = 60
11 x 4 = 44 11 x 5 = 55 11 x 6 = 66
12 x 4 = 48 12 x 5 = 60 12 x 6 = 72
13 x 4 = 52 13 x 5 = 65 13 x 6 = 78

For example, in case of 9 x 6 = 54, as 9 is greater than 6, i want to swap 9 & 6. So, it would look like 6 x 9 = 54

How can I do that?

Just swap ROW(B2)-1 and COLUMN(B2)-1:
=(IF(COLUMN(B2)-1>ROW(B2)-1;"";COLUMN(B2)-1&" x "&ROW(B2)-1&" = "&(ROW(B2)-1)*(COLUMN(B2)-1)))

1 Like

Thank you very much.