Adding 5 values and dividing does not work

Robert K

Hi all ! Help!

I am trying to add these 5 cells and then divide by 5. But I get this odd number 4.2??

Please note the H/L columns also has a formula

The COLOR(A-E) columns has a conditional formula to turn red/green

Thank you!

Genevieve P.

Hey @Robert K

Right now you are adding the first three cells together (using these parentheses) to keep the values together, then adding 4 and 5 separately, and then dividing by 5. This means that only [5th Patient H/L]@row is being divided by 5 instead of the total.

=(1 + 2 + 3) + 4 + 5 / 5

You'll want to structure your formula like this:

=(1 + 2 + 3 + 4 + 5) / 5

Cheers,

Genevieve