![]() More complex decisions (Nested IF Statements) The first argument can be any expression that can be true or false, usually using =,>,= or. Returns the text Greater than three if the number in cell A2 is greater than 3 and Not greater than three, if it is not. =IF(A2>3,"Greater than three","Not greater than three") =IF(if this is true,return this,otherwise return this) The basic format of an IF statement is as follows: This function is very powerful and to many can seem very complicated, whereas to others it is deceptively simple and its power can be underestimated. ![]() One of the functions I use most often in Excel is the IF statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |