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.
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!
OliverScheurich
May 05, 2022Gold Contributor
You are welcome. You can try the attached file.