# Pull a min value from cells

#### Spoontang

##### New Member
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,))

Last edited:

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Yongle

##### Well-known Member
=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
O
P
Q
R
31
32
35​
125​
35​
=MIN(O32,P32)
33
 Sheet: Sheet1

Text in BOTH cells

Excel 2016 (Windows) 32 bit
O
P
Q
R
31
32
35125
0​
=MIN(O32,P32)
33
 Sheet: Sheet1

Text in O32, number in P32

Excel 2016 (Windows) 32 bit
O
P
Q
R
31
32
35
125​
125​
=MIN(O32,P32)
33
 Sheet: Sheet1

#### Spoontang

##### New Member
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

##### Well-known Member
Thanks for the feedback. Glad it worked.