If function greater than, less than, with positive and negative numbers

[mkikas]

I look, but i didn't found an answer for these. I need a formula, that will give me a value between two cells, where one is allways negative, the other positive, and the result should be always negative but the value will be one or the other one. I am using the formula =IF(B2>B3,B3,B2), the issue is that B2 is a negative number and B3 a positive, and formula allways return me B2. Bellow, i give the examples, of what i need to happened in just one column. so, in the column B (Formula) is where i put the formula, that is not working, in columns C (Ex:1) and D (Ex:2), is what i need to happens when i insert the formula.

	Formula	Ex:1	Ex:2
Capex to be Recovered	-170​	-170​	-40​
Capex allowed to recover in the Month	50​	50​	50​
Capex recovered in the month	-170​	-50​	-40​

Thanks in advance for your support.

 

[mkikas]

I am sorry, i made a mistake, the value in the last row (Capex recovered in the month) should be always positive, and not negative, so the table should be:

	Formula	Ex:1	Ex:2
Capex to be Recovered	-170	-170	-40
Capex allowed to recover in the Month	50	50	50
Capex recovered in the month	170	50	40