Thread: IF, then
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default IF, then

Try this example will test if A1=1 And B1=2 Then Sum A1 + B1 =3
=IF(AND(A1=1,B1=2),A1+B1,"False")



"Puffin1" wrote:

How do I write the formula for "If A1 is true, then B1 is also true and the
result = A1+B1