Excell Formula

R

Rolou

How doI formulate the following:
if A1 is thruth and if A2 is thruth then A3 equal 1
 
O

Otto Moehrbach

What do you mean when you say "A1 is True"? What constitutes True? HTH
Otto
 
B

Bob Phillips

=IF(AND(A1=TRUE,A2=TRUE),1,2)

is that what you mean?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
J

joeu2004

Rolou said:
How doI formulate the following:
if A1 is thruth and if A2 is thruth then A3 equal 1
Click to expand...

Depending on your definition of "true", put one of the following in A3:

=1*and(n(A1),n(A2))

=1*and(A1=true, A3=true)

The N() function ensures that AND() works even if A1 or A2 is blank.
The first formula treats any non-blank non-zero value in A1 or A2 as
true.
 
Top