Pull a min value from cells

[Spoontang]

This should be basic, but it isn't working for me for some reason.
I have two cells containing a number from IF formulas, I want the lowest number in another cell.
The =MIN returns 0, I thought it maybe from the IF formulas??
So I put an IF which is =IF(O32<P32,<p32,<p32,o32,if(p32<o32,p32,))
O32,IF(P32<<o32,p32,))
O32,P32))
O32 is 35 at present, P32 is 125, it is returning 125.
Why I don't know, any ideas on fixing it please?
Cheers</o32,p32,))
</p32,<p32,o32,if(p32<o32,p32,))

 

[Yongle]

=MIN(O32,P32)

returns the lower number, but returns 0 if BOTH O32 & P32 are returning a TEXT string

Numbers in BOTH cells

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

O​

[/th][th]

P​

[/th][th]

Q​

[/th][th]

R​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

31​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

32​

[/td][td]

35​

[/td][td]

125​

[/td][td]

35​

[/td][td] =MIN(O32,P32)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

33​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

Text in BOTH cells

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

O​

[/th][th]

P​

[/th][th]

Q​

[/th][th]

R​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

31​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

32​

[/td][td]35[/td][td]125[/td][td]

0​

[/td][td] =MIN(O32,P32)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

33​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

Text in O32, number in P32

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

O​

[/th][th]

P​

[/th][th]

Q​

[/th][th]

R​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

31​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

32​

[/td][td]35[/td][td]

125​

[/td][td]

125​

[/td][td] =MIN(O32,P32)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

33​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[Spoontang]

Cheers Yongle, I had tried to format the cells to numbers but that didn't work. After your reply I changed the IF formula that was feeding the two cells to pull numbers instead of what probably was adding them as text. Fixed the problem.

 

[Yongle]

Thanks for the feedback. Glad it worked.