How Can I Create A Point System On Excel?
Like if A Team has 50 points and B Team has 80 points, I would like Excel to have a message read (for B Team): "Congratulations you have won this challange".
if your totals for team A were in A7 and b's in B7 then try this in some cell for Team B's result
=IF(B7>A7,"Congratulations Team B you have won this challange","")
if you want to get fancy and do all results in 1 box
=IF(A7=B7,"Team A and Team B are tied",IF(B7>A7, "Congratulations Team B you have won this challange", "Congratulations Team A you have won this challange"))
PS: to add up the stuff in A1 through A5, you put this in A7
=sum(A1:A5)
=IF(B7>A7,"Congratulations Team B you have won this challange","")
if you want to get fancy and do all results in 1 box
=IF(A7=B7,"Team A and Team B are tied",IF(B7>A7, "Congratulations Team B you have won this challange", "Congratulations Team A you have won this challange"))
PS: to add up the stuff in A1 through A5, you put this in A7
=sum(A1:A5)
if your totals for team A were in A7 and b's in B7 then try this in some cell for Team B's result
=IF(B7>A7,"Congratulations Team B you have won this challange","")
if you want to get fancy and do all results in 1 box
=IF(A7=B7,"Team A and Team B are tied",IF(B7>A7, "Congratulations Team B you have won this challange", "Congratulations Team A you have won this challange"))
PS: to add up the stuff in A1 through A5, you put this in A7
=sum(A1:A5)
=IF(B7>A7,"Congratulations Team B you have won this challange","")
if you want to get fancy and do all results in 1 box
=IF(A7=B7,"Team A and Team B are tied",IF(B7>A7, "Congratulations Team B you have won this challange", "Congratulations Team A you have won this challange"))
PS: to add up the stuff in A1 through A5, you put this in A7
=sum(A1:A5)