How to get a formula result in a "whatif" situation
 

I need to use a formula that will do the following:
Note: All entries are given numbers in compiling a survey. The following
cells can be any combination of "1".
A1=1 or A1=0
B1=1 or B1-0
I want C1 to return a 1 only if both A1 and B1 are 1. C1 should return a 0
in all other instances.

How to get a formula result in a "whatif" situation
 

in cell C1:
=IF(AND(A1=1,B1=1),1,0)

"TG9522" wrote in message
...
I need to use a formula that will do the following:
Note: All entries are given numbers in compiling a survey. The following
cells can be any combination of "1".
A1=1 or A1=0
B1=1 or B1-0
I want C1 to return a 1 only if both A1 and B1 are 1. C1 should return a
0
in all other instances.

How to get a formula result in a "whatif" situation
 

=a1*b1 if values are 1 or 0

OR

=If(and(a1=1,b1=1),1,0)

"TG9522" wrote:

I need to use a formula that will do the following:
Note: All entries are given numbers in compiling a survey. The following
cells can be any combination of "1".
A1=1 or A1=0
B1=1 or B1-0
I want C1 to return a 1 only if both A1 and B1 are 1. C1 should return a 0
in all other instances.