Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |