how can i check for #Value! ? ... or how do I do MaxIf??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brett - 19 Jun 2006 20:39 GMT

How can I check for #Value! in a cell? ie If(c4 = #Value!, 0, 1).

Alternatively, is there a way of looking for the maximum value in a column
based upon a second column meeting a certain criteria?

The example is
1
2a
3
2b
2b
4
2c

I need to know that stream 2 has three splits (the double 2b entry is
intentional).

Thanks,
Brett

Reply to this Message

Marcelo - 19 Jun 2006 20:54 GMT

Hi,

try to use

if(iserror(c4),0,1)

hope this help
regards from Brazil
Marcelo

> How can I check for #Value! in a cell? ie If(c4 = #Value!, 0, 1).
>
[quoted text clipped - 15 lines]
> Thanks,
> Brett

Reply to this Message