You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
This is a quiz scoreboard xls file I found online. Putting a number in the Joker row doubles that round's score. Can anyone suggest cleaner code that will get rid of the blue triangle in the totals boxes? The blue box disappears when something is entered in the joker cell. Many Thanks.
It is the IF part of the formula. An IF statement is of this form:
IF(condition, if_true, if_false)
In your formula the parameters are
condition: B4≠""
if_true: OFFSET(B4,B4,0)
if_false: this was left off (which is allowed) so it will be the boolean value FALSE
so if B4≠"" (something is in the Joker cell) it does OFFSET(B4,B4,0) which gets a numeric value from a cell below B4.
But if B4="" (Joker cell is empty) the result will be the boolean FALSE. Your formula adds that boolean FALSE to a sum of numbers, thus the warning message.
Bottom line is to give the IF statement a value for if_false
=SUM(B5:B12)+IF(B4≠"",OFFSET(B4,B4,0),0)
It is the IF part of the formula. An IF statement is of this form:
IF(condition, if_true, if_false)
In your formula the parameters are
condition: B4≠""
if_true: OFFSET(B4,B4,0)
if_false: this was left off (which is allowed) so it will be the boolean value FALSE
so if B4≠"" (something is in the Joker cell) it does OFFSET(B4,B4,0) which gets a numeric value from a cell below B4.
But if B4="" (Joker cell is empty) the result will be the boolean FALSE. Your formula adds that boolean FALSE to a sum of numbers, thus the warning message.
Bottom line is to give the IF statement a value for if_false
=SUM(B5:B12)+IF(B4≠"",OFFSET(B4,B4,0),0)
Thanks, that worked perfectly!!
The formula uses a Boolean in place of a number
