Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo

Found the Problem, some formulas produced #N/A,
so the MAX statement produces #N/A too :(

Is there a solution for this?

Thanks Carlo

"Carlo" wrote:

Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo

Try this instead of simply yourfunction():
=IF(ISERROR(yourfunction()),"",yourfunction())

Regards,
Stefi



€žCarlo€� ezt Ã*rta:

Found the Problem, some formulas produced #N/A,
so the MAX statement produces #N/A too :(

Is there a solution for this?

Thanks Carlo

"Carlo" wrote:

Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo

Check for the #N/A condition and "remove" it

=IF(ISNA(formula),"",formula)



"Carlo" wrote:

Found the Problem, some formulas produced #N/A,
so the MAX statement produces #N/A too :(

Is there a solution for this?

Thanks Carlo

"Carlo" wrote:

Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo

Thanks guys

i forgot to mention, that i produce the #N/A by myself
otherwise my chart doesn't look right :(
That's why I can't get rid of the "errors"

Thanks a lot to both of you for your Help

Carlo


"Toppers" wrote:

Check for the #N/A condition and "remove" it

=IF(ISNA(formula),"",formula)



"Carlo" wrote:

Found the Problem, some formulas produced #N/A,
so the MAX statement produces #N/A too :(

Is there a solution for this?

Thanks Carlo

"Carlo" wrote:

Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo

=MAX(IF(ISNUMBER(rng),rng))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Carlo" wrote in message
...
Found the Problem, some formulas produced #N/A,
so the MAX statement produces #N/A too :(

Is there a solution for this?

Thanks Carlo

"Carlo" wrote:

Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo

Hi Bob

brilliant, exactly what i was searching for.

Never heard of array formulas before, have to take
a look at them. You never stop learning :)

Thanks again to all of you

Cheers Carlo

"Bob Phillips" wrote:

=MAX(IF(ISNUMBER(rng),rng))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Carlo" wrote in message
...
Found the Problem, some formulas produced #N/A,
so the MAX statement produces #N/A too :(

Is there a solution for this?

Thanks Carlo

"Carlo" wrote:

Hi all

got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to get the Maximum
out of this range, i only get a #N/A :(
does anyone know, how i still can get the Maximum
of all numbers in that range?

Thanks for your Help

Carlo