Thanks,

Rick anwers is the most suitable one while sorry topper yours is not working

--
Sincerely Yours
Haviv


"Rick Rothstein (MVP - VB)" wrote:

I have four five each contain number 5, 2, 3, 4, 6 in cell A1 to E1.
Now in a new cell let's say B1 i need to select the minum positive value
from below formula

formula 1 A1-B1 = 3
formula 1 A1-C1 = 2
formula 1 A1-D1 = 1
formula 1 A1-E1 = -1

How do i develop a formula to be able to show the value of (A1-D1) which
is
the minimum positive value.

Probably not the most compact formula, but it does seem to do what you
asked...

=MIN(IF(A1-B1<=0,1E+300,A1-B1),IF(A1-C1<=0,1E+300,A1-C1),IF(A1-D1<=0,1E+300,A1-D1),IF(A1-E1<=0,1E+300,A1-E1))

Rick