Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Formula
How doI formulate the following:
if A1 is thruth and if A2 is thruth then A3 equal 1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
formula - excell | Excel Worksheet Functions | |||
Why would a formula stop working in an Excell spreadsheet? | Excel Worksheet Functions | |||
Formula in Excell | Excel Worksheet Functions |