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

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

Thank you for your assistance. I assume that checking the 'Iteration' check
box will have no noticeable effect on the operation of the workbook.

Jerry

--
Saskatoon Jerry


"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

Can't guarantee, but if you don't have any other circular references
you're probably safe.

See the "Change the number of times Microsoft Excel calculates, or
iterates, a formula" in XL Help.

In article ,
Saskatoon Jerry wrote:

Thank you for your assistance. I assume that checking the 'Iteration' check
box will have no noticeable effect on the operation of the workbook.

"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.

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.