Question: Create and copy an IF function. Select the By Policy sheet and click cell F 7 . Start an IF function with the logical _

Create and copy an IF function. Select the By Policy sheet and click cell F7. Start an IF function with the logical_test E7=business policy to determine if the policy is for a business. If it is for an individual, it is a personal line policy. You must type the quotation marks because text follows the cell reference. Type No as the Value_if_true argument. You need not type quotation marks for this argument because it is alone in the entry box. Type Yes as the Value_if_false argument (Figure 2-108). IF function that uses text in the logical_argument Figure 2-108 IF function that uses text in the logical_argument Copy the formula in cell F7 to complete the column. If it is a business policy, the result is No because the label in cell F6 asks if it is a personal line. Increase the indent two times for cells F7:F27. Press fn+control+Left Arrow.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!