Pull a min value from cells

Spoontang

New Member
Joined
Jan 25, 2018
Messages
10
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:

Some videos you may like

Excel Facts

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

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,357
Office Version
365
Platform
Windows
=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
Joined
Jan 25, 2018
Messages
10
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
Joined
Mar 11, 2015
Messages
6,357
Office Version
365
Platform
Windows
Thanks for the feedback. Glad it worked.
(y)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,542
Messages
5,487,469
Members
407,602
Latest member
clang663

This Week's Hot Topics

Top