Formula Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

the-jackal - 05 Oct 2006 15:38 GMT

Hope someone can help,

I am using this formula =IF(AND(G12="Fail"),"1","0") and need to add u
all the column but I keep getting 0 even though there are 14 1’s in th
column.

Thanks in advance

Car

--
the-jackal

Reply to this Message

Dave Peterson - 05 Oct 2006 19:45 GMT

Drop the double quotes around the numbers:
=IF(AND(G12="Fail"),1,0)

Otherwise, those values will be treated as text.

> Hope someone can help,
>
[quoted text clipped - 8 lines]
> --
> the-jackal

Signature

Dave Peterson

Reply to this Message

Pete_UK - 05 Oct 2006 21:27 GMT

I'm not sure why you need the AND in there, and you don't need the
double-quotes, as the returned values will be treated as text (and thus
sum to zero). Try this

=IF(G12="Fail",1,0)

and copy down the column as needed.

Hope this helps.

Pete

> Hope someone can help,
>
[quoted text clipped - 5 lines]
>
> Carl

Reply to this Message

Rate this thread: