- Thank you received: 0
Counticon
- CBashford
- Topic Author
- Offline
Less
More
2 years 8 months ago - 2 years 8 months ago #9602
by CBashford
Counticon was created by CBashford
Hi,
I’ve been trying to set up a calculation using the “if” and “counticon” functions, but am struggling to get a working formula.
I have my class linked to google classroom, and assignment marks are imported.
I have set a quick calculation to get the percentage/colour.
For any student who has not handed in the homework, I have added the cross icon (❌) .
I want to have a formula which counts how many crosses for each student, then returns a 1️⃣/2️⃣/3️⃣ depending on how many homework handed in (or in this case, how many are not handed in )
Thanks
I’ve been trying to set up a calculation using the “if” and “counticon” functions, but am struggling to get a working formula.
I have my class linked to google classroom, and assignment marks are imported.
I have set a quick calculation to get the percentage/colour.
For any student who has not handed in the homework, I have added the cross icon (❌) .
I want to have a formula which counts how many crosses for each student, then returns a 1️⃣/2️⃣/3️⃣ depending on how many homework handed in (or in this case, how many are not handed in )
Thanks
Last edit: 2 years 8 months ago by CBashford.
Please Log in or Create an account to join the conversation.
- CBashford
- Topic Author
- Offline
Less
More
- Thank you received: 0
2 years 8 months ago #9603
by CBashford
Replied by CBashford on topic Counticon
Please Log in or Create an account to join the conversation.