Forum Discussion
IFS and AND
Hi. Please can you help. I am using this formula for a scoring system using total scores from 3 worksheets. The scores have a range as per the formula. =IFS(C30<=38%,"White",C30<=62%, "Bronze", C3...
What is the formula you're currently using to calculate the total score?
HansVogelaar on each sheet, I have just used the SUM function to total each score (each question is out of 4) divided by the total possible score for that worksheet, I have then made it a percentage. Then I have used the IFS formula above to tell me gold, silver etc according to the range.