Reverse the operator and add an additional test for blank. Otherwise, if A1
is blank (empty) then B1 will return 0. If you're dealing with positive
numbers then you'll never get a min value that's less than the empty cell
value of 0.

=IF(A1="","",IF(A1<B1, A1, B1))

--
Biff
Microsoft Excel MVP


"vshak" wrote in message
...


"JE McGimpsey" wrote:

One way:

Choose Tools/Options/Calculation and check the Iteration checkbox.

to monitor cell A1 in cell B1, enter this in B1:

=IF(A1B1, A1, B1)



In article ,
Saskatoon Jerry wrote:

Looking for a function or macro that captures and retains the maximum
value
of a fluctuating real number in a cell

how would you capture the MINUMUM of a fluctuating real number in another
cell using the formula you give above.