Highest value formula in Excel?
I have a spreadsheet with my savings accounts amounts plus intrest. Now what I’m trying to do is make a new cell that will keep track of the highest point of the total amount through all acounts so I can always look back to see where my peak amount was even if my total goes lower due to expenses. I have hit a snag and for the life of me i can’t figure how how to write it.
you don’t say how your sheet is setup.
if your savings totals are in cells B1 to B99
then use the MAX() function to tell you what this highest number is.
=MAX(B1:B99)
you can change the range to B1:B999 or whatever incase you want to add more rows later.
if your B column is linked to dates, then you can use an INDEX() and MATCH() formula to show what date the MAX() was on.
hope this helps
PAYROLL CHECKS USING EXCEL READY TO PRINT