Max Cell Value

S

Saskatoon Jerry

Looking for a function or macro that captures and retains the maximum value
of a fluctuating real number in a cell
 
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)
 
S

Saskatoon Jerry

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
 
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.
 
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)
Click to expand...

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a minimum value in a cell that is constantly changing. 1
Word macro that can call cells out of Excel for a find and replace 0
Trying to find additional ranges outside of min, max, and average 2
Compressing multiple functions across an array into one cell 6
How can i find the max value within a time range ased on two cells 6
MAX Function Issue 2
Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2

Top