Excel Formula - to calculate highest number from a set of numbers

E

Emily

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?
 
M

Max

Emily said:
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?
Click to expand...

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