PDA

View Full Version : Solved: maximum function with #na value



nitzbar
08-18-2008, 04:05 PM
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
08-18-2008, 04:36 PM
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
08-18-2008, 04:40 PM
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
08-19-2008, 01:07 AM
=G13-MAX(IF(ISNUMBER(C13),C13,0),IF(ISNUMBER(E13),E13,0))

nitzbar
08-19-2008, 07:31 AM
thanks a lot... this works....