Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula - to calculate highest number from a set of numbers
I have a list of about 14 numbers in each row, and I need a formula that
calculates the highest number out of a specified set eg. =max(c2, e2, g2, j2). The problem is that some lines require two cells to have this formula and when I do that it creates a circular reference. How can I fix this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula - to calculate highest number from a set of numbers
"Emily" wrote:
I have a list of about 14 numbers in each row, and I need a formula that calculates the highest number out of a specified set eg. =max(c2, e2, g2, j2). The problem is that some lines require two cells to have this formula and when I do that it creates a circular reference. How can I fix this? Not very sure .. but are you having problems because of merged cells ? Try removing the merged cells, then re-enter the formula .. (It's best to avoid using merged cells) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel formula to calculate % gain when adding cash equity to accou | Excel Worksheet Functions | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |