| 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? |
| 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 | |||
Threaded Mode
