Excell Formula
 

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

Excell Formula
 

What do you mean when you say "A1 is True"? What constitutes True? HTH
Otto
"Rolou" wrote in message
...
How doI formulate the following:
if A1 is thruth and if A2 is thruth then A3 equal 1

Excell Formula
 

=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)

"Rolou" wrote in message
...
How doI formulate the following:
if A1 is thruth and if A2 is thruth then A3 equal 1

Excell Formula
 

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

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.