Answered

Suppose you are watching football and you create a
spreadsheet to help you calculate the score. You
would like the final result to display the word
"Score:" along with the score in the same cell, which
is the sum of cells C1 through C4. If the score is
equal to zero, display "No score yet". Which formula
would accomplish this?
A =IF(SUM(C1:C4)<0, "Score: " & SUM(C1:C4),
"No score yet")
B =IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4),
"No score yet")
C =IF(SUM(C1:C4)>0, "No score yet", "Score: " &
SUM(C1:C4))

Verified Answer :

GinnyAnswer

To determine the correct formula for displaying the word "Score:" along with the sum of the cells C1 through C4 if the sum is zero, and "No score yet" otherwise, let's analyze each option provided.

1. Option A:
``
=IF(SUM(C1:C4)<0, "Score: " & SUM(C1:C4), "No score yet")
`
- This formula checks if the sum of C1 through C4 is less than zero.
- If the sum is less than zero, it displays "Score: " followed by the sum.
- Otherwise, it displays "No score yet".
- This formula does not align with what we need since we are interested in checking if the sum is exactly zero.

2. Option B:
`
=IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4), "No score yet")
`
- This formula checks if the sum of C1 through C4 is equal to zero.
- If the sum equals zero, it displays "Score: " followed by the sum.
- Otherwise, it displays "No score yet".
- This formula meets our requirement as it checks if the sum is zero and displays the appropriate message.

3. Option C:
`
=IF(SUM(C1:C4)>0, "No score yet", "Score: " & SUM(C1:C4))
`
- This formula checks if the sum of C1 through C4 is greater than zero.
- If the sum is greater than zero, it displays "No score yet".
- Otherwise, it displays "Score: " followed by the sum.
- This formula also does not align with our needs since it checks for a condition that is the reverse of what we need.

Having analyzed all the options, we can conclude that Option B correctly implements the required logic:

`
=IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4), "No score yet")
``

This formula will display "Score: 0" if the sum of cells C1 through C4 is zero, and "No score yet" otherwise.

Related Questions