LinkBack URL
About LinkBacks
Can anyone help with a formula please.
I have 6 cells in a table that each contains a value of anything between 1 and 4.
I need a formula that will return the highest value contained within these 6 cells.
Returning the highest value in a range
Can anyone help with a formula please.
I have 6 cells in a table that each contains a value of anything between 1 and 4.
I need a formula that will return the highest value contained within these 6 cells.
try
=max(A1:A6)
If your data is not contiguous, you can use something like
=MAX(B2,C7,E7,F9,G4)
adjust ranges to suit your data cells.
Hi,
=MAX(range)
so if your cells are A1 to A6,
=MAX(A1:A6)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Brilliant! Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks