Home » questions » How can I create a point system on Excel?

How can I create a point system on Excel?

2006-08-05 04:22:01, Category: Programming & Design
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".

Answers

  1. PC Doctor

    On 2006-08-05 06:12:53


    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)