I need a comand that would take value from A and B colum and pick the smaller one to put in colum C. But if obe colum has no value it has to choose the one with value. Like If colum A row 2 value is 0 and in colum B row 2 value is 20. It hase to choose 20.I realy strugle with excel and if you could help me that would be nice. thank you in advance


A B C
15 36 15 It piks the colum A because 15 is less than 36
0 20 20 It piks the colum B because any number is better than 0
60 75 60 It piks the colum A because 60 is less than 75
5 4 4 It piks the colum B because 4 is less than 5
49 0 49 it piks the colum B beacause anynumber is better than 0
And so on

Thank you !