Question

In cell e12, enter an if function that will return yes if there is a uniform size on record and a permission slip has been returned, otherwise return no. copy the formula down through e34

Answer 1

To input a conditional IF function in Excel, combine the IF and AND functions to check if there is a uniform size on record and if a permission slip has been returned, returning 'Yes' only when both conditions are satisfied. This formula should be copied from cell E12 through E34.

Step-by-step explanation:

To answer the student's question regarding an IF function in Excel, here's what they'll need to do in cell E12:

=IF(AND(uniform_size_cell<>"", permission_slip_cell="Yes"), "Yes", "No")

In this formula, uniform_size_cell should be replaced with the reference to the cell that contains the uniform size data, and permission_slip_cell with the cell reference that indicates if a permission slip has been returned. The AND function checks both conditions: whether there is a uniform size on record (i.e., the cell is not empty) and if a permission slip has been returned (i.e., the cell says 'Yes'). If both conditions are met, the function returns 'Yes', otherwise it returns 'No'.

To copy the formula down from E12 through E34, the student can simply drag the fill handle (a small square at the bottom-right of the cell highlight) down to cell E34 after entering the formula in E12.