Forum Discussion

FreddyJay's avatar
FreddyJay
Copper Contributor
Nov 03, 2021
Solved

Compare cells, if true, result in another column

Hi all, See attachment for example My students takes an exam. Student has 19 points (M5 =SUM(C5:L5)) of 110 points. 2,6 is than the result of the student his exam I want to compare colums ...
excel
  • FreddyJay's avatar
    FreddyJay
    Nov 03, 2021
    Never mind, i've , replaced with ; and it works.

    Thanks!
FreddyJay's avatar
FreddyJay
Copper Contributor
Nov 03, 2021
Thanks for your reply Quadruple. When i do this, i've got an error

there's a problem with this formula not trying to type a formula
When the first characater is an equal......

What to do?
FreddyJay's avatar
FreddyJay
Copper Contributor
Nov 03, 2021
Never mind, i've , replaced with ; and it works.

Thanks!

Resources