How do you write an Excel "if and" statement?

Answer by  worker83 (62)

Excel has a built-in tutorial for this, I suggest you use that if you aren't too familiar with Excel. Depending on your Excel version, you can probably find it under 'Formulas' or maybe 'Insert' > 'Formula'. You can also insert it manually by typing the following in a cel: =IF(An_Expression,"Positive_message","Negative_message").

Answer by  SashaDarkCloud (5764)

IF=(AND(your formula here),2nd formula,"result"). Just make sure that if you want more conditions, that you put it between the braces near the AND. Also make sure that you have referenced the correct cells or else the code won't work.

Answer by  joy55 (22)

The excel "IF AND" statements looks at the excel cell values. For example, on cell A1 if you write the "IF AND" as =if(and(B1="K", C1="R"),"100","200"), it means that if cell B1 has a value of K and cell C1 has a value of R then A1 will have value of 100 else it will have a value of 200

Answer by  abans (43)

There are 2 ways of AND. 1) =IF(((value<=>test) AND (value2<=>test2)), if_test_true, if_test_false) 2) =IF(value<=>test, (IF(value2<=>test2, if_test_true, if_test_false), if_test_false). if_test_true represents answer if conditions are met.

Answer by  Mariam (23)

Let's say you have this situation and want to write it at Excel: IF A2=120 AND C3>20 THEN WRITE 0 ELSE WRITE 1 IN EXCEL: =IF(AND(A1=120,C3>20),0,1)

Answer by  gigo (1706)

In Excel if is a function like any other, but the and does not exists. You can help yourself by nesting the if statements: IF(A1=3;IF(A2=5;TRUE;FALSE);FALSE). Keep in mind that the excel function names are language dependent.