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 M with column O and column O with column P.

Result column P sets automatically in column B

 

Example:

I want that Excel automatically set B5 to 2,6

 

M5 result compare with O1:O223, if true compare it with P1:P223 and that's the result for B5.

What's the correct formula?

  • Never mind, i've , replaced with ; and it works.

    Thanks!

3 Replies

    • FreddyJay's avatar
      FreddyJay
      Copper Contributor
      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
        Never mind, i've , replaced with ; and it works.

        Thanks!

Resources