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.
I'm still confused. Is the formula that you posted for one sheet, or is it a summary formula that combines the three sheet scores?
- Sorry I know, I'm confusing myself! On the main title page where I want it to display gold, silver etc, I have already totalled the 3 sheets to make one grand total score on cell C30. This is what the formula is working on.
