Forum Discussion
anacrisp
May 05, 2022Copper Contributor
Conditional Formatting based on two cells, output in a third.
Maybe conditional formatting won't help at all. Please don't mind the English as I have translated. Also this is what was given me by my MIL to help. So I have this grading sheet where I have tw...
- May 05, 2022
You are welcome. You can try the attached file.
OliverScheurich
May 05, 2022Gold Contributor
Maybe as shown in the attached file.
anacrisp
May 05, 2022Copper Contributor
thank you so much for the help!
If i may ask for a little more help..
If the person did not take the test, they are mark absent on the grade column (B and D columns), therefore as ELIMINATED on the Final (G column)
How could I add to the formula, if possible?
Thank you so much once again!
If i may ask for a little more help..
If the person did not take the test, they are mark absent on the grade column (B and D columns), therefore as ELIMINATED on the Final (G column)
How could I add to the formula, if possible?
Thank you so much once again!
- OliverScheurichMay 05, 2022Gold Contributor
You are welcome. You can try the attached file.