Type a plus sign then use your pointer to select C2 to enter the second cell reference into the formula. If And in excel are the two most different functions which are usually nested together in a simple If function we can only test a single criteria but if we use the logical AND function we can test more than one criteria and give output based on the criteria they are used as follows IF Condition 1 AND Condition 2 Value if true Value if False. Either type the formula in the Formula Bar or use the Function Arguments dialog box.
Step 3 We repeat the same addition equation for each and every bill.
IF B21000PERFECTTOO SMALL This function has the following arguments. IF B22500ExcellentIF B22000GoodIF B21000AveragePoor In C2 write down the above formula and press enter. Value_if_true argument type Underweight. IF AND condition1 condition2 value_if_true value_if_false Translated into plain English the formula reads as follows.