Formula help appreciated

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Please see table below I am trying to check if entires in columb b & c are
both corrcet (1 indicates correct, 0 incorrect and blank no entry).

If both are correct this indicated in Column C as a 1. I then have to sum
all the entries in Column C and calculate the percentage of correct both A &
B together.

The problem I have is that I am using an if statement IF(b3+c3=2,1,0)
this will not work if there is NO entry as in a5 and b5 I get the error
signal ###.

Unfortunatley, sometimes there will not be an entry in both columns in a &
B. So I would like help in trying to ignore the entries where ther is noe
entry?

I hope this makes sense.

Regards Bill

Column B Column C Column D

a1 A correct B correct Both correct
a2
a3 0 1 0
a4 1 1 1
a5
a6 0 0 0
a7 1 0 0
 
If I've understood you correctly,

This formula

=--(B3=1)*(C3=1)

will return 1 if B3 & C3 are both 1
In all other cases, it returns 0
 
Steve,

You don't need the --, the * achieves the same objective of coercing the
Booleans to a value. so

=(B3=1)*(C3=1)

is sufficient

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Quite right. I put

=--(B3=1)

in a cell to rid myself of the uneasy feeling that "True" might = "-1"
(too many languages) and forgot I could do without it later :-(
 
Anything wrong with:

=B3*C3
??

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Quite right. I put

=--(B3=1)

in a cell to rid myself of the uneasy feeling that "True" might = "-1"
(too many languages) and forgot I could do without it later :-(
 
The OP's own formula appears to work OK with 1, 0 or blank

I assume he has spaces in some of his cells.
 
Back
Top