G
Guest
Looking for a function or macro that captures and retains the maximum value
of a fluctuating real number in a cell
of a fluctuating real number in a cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
Choose Tools/Options/Calculation and check the Iteration checkbox.
to monitor cell A1 in cell B1, enter this in B1:
=IF(A1>B1, A1, B1)
Choose Tools/Options/Calculation and check the Iteration checkbox.
to monitor cell A1 in cell B1, enter this in B1:
=IF(A1>B1, A1, B1)
G
Guest
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
box will have no noticeable effect on the operation of the workbook.
Jerry
J
JE McGimpsey
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.
you're probably safe.
See the "Change the number of times Microsoft Excel calculates, or
iterates, a formula" in XL Help.
V
vshak
JE McGimpsey said:One way:
Choose Tools/Options/Calculation and check the Iteration checkbox.
to monitor cell A1 in cell B1, enter this in B1:
=IF(A1>B1, A1, B1)
how would you capture the MINUMUM of a fluctuating real number in another
cell using the formula you give above.
T
T. Valko
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))
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))