QA.TechInterviews.com - your tech questions answered
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 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)

Back to QA. TechInterviews.com. Powered by Yahoo! Answers and TechInterviews.com community.