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 F Start an IF function with the logicaltest Ebusiness 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 Valueiftrue argument. You need not type quotation marks for this argument because it is alone in the entry box. Type Yes as the Valueiffalse argument Figure IF function that uses text in the logicalargument Figure IF function that uses text in the logicalargument Copy the formula in cell F to complete the column. If it is a business policy, the result is No because the label in cell F asks if it is a personal line. Increase the indent two times for cells F:F Press fncontrolLeft Arrow.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
