Create the following range names B4B23 Claims C4C23 AtFault

Create the following range names:

B4:B23 Claims

C4:C23 AtFault

D4:D23 Rating

E4:E23 Deductible

Using the named ranges, created a formula in cell G4 to display the text Yes if the number of at-fault claims is greater that one and the current rating is greater than two. Both conditions must test true to display Yes;otherwise,display No in the cell. Hint: use a nested IF and AND formula.

Solution

IF the question is to check based on total then the formula in G4 is:

=IF(AND(SUM(atfault)>1,SUM(rating)>2),\"Yes\",\"no\")

If it is for each cell then it is :

=IF(AND(C4>1,D4>2),\"Yes\",\"no\")