THis is my sample data:
A B C
1. 34 23 34
2. 54 43 54
3. -6 -8 -6


Whe i use simple function of =MAX(A1:B1) then i got 34 in C which is what i want.

When i use =MAX(A3:B3) the i get -6 in C. My question is how can i make -8 in B3 become the the max # when i use function =MAX(A3:B3) ?

because the number -8 is bigger than the -6 here in our place. The computer has assume the -6 is grater than -8.

Thanks