# Thread: Pull a min value from cells Thanks: 0 Likes: 0

1. ## Pull a min value from cells

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 O32,IF(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

2. ## Re: Pull a min value from cells

=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
35 125
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

3. ## Re: Pull a min value from cells

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.

4. ## Re: Pull a min value from cells

Thanks for the feedback. Glad it worked.