Solved: maximum function with #na value

[nitzbar]

Hi !

I need to use the 'maximum' function while inclusing a cell that has a #na entry. This doesn't seem to work. Any suggestions ? I need the # na value in the cell as I need to graph that set of values.

[stanleydgrom]

nitzbar,

You could modify the formula to display a certain value if the formula is in error.

Please post the formula that is displaying the "#N/A" error value.


Have a great day,
Stan

[nitzbar]

for e.g

G13-MAX(C13,E13)

if either c13 or e 13 is#n/a , the result is #n/a , when i would like it to calculate and return a value since the other cell contains a valid number.

[Bob Phillips]

=G13-MAX(IF(ISNUMBER(C13),C13,0),IF(ISNUMBER(E13),E13,0))

[nitzbar]

thanks a lot... this works....