Thread: Excell Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default 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