I want to have a summation of data cells with different values (A1, B1, C1, D1,E1 & F1) where G1 is the value of summation (Formula)
Knowing that each of the data cells should have a ceiling of “9”
So that:
- If A1<=9 then the summation would return its original value, else if A1>9 the summation would return its value to “9”. For example, even if A1 value is “14”, then G1 should add its value as “9”
- If B1<=9 then the summation would return its original value, else if B1>9 the summation would return its value to “9”

The same loop should exist with C1, D1, E1 and F1

The goal is not to change the cell value itself, but to add maximum “9” of its value to cell G1

So that the summation result in G1 can be maximum equal to (9*6); 54

I’m looking for a summation formula of data cells with different values (A1, B1, C1, D1,E1 & F1) where G1 is the value of summation
Knowing that each of the data cells should have a ceiling of “9”
- If A1<=9 then the summation should return its original value, else if A1>9 the summation would return its value to “9”. For example, even if A1 value is “14”, then G1 should add its value as “9”

The same applies to other cells

So that the summation result in G1 can be maximum equal to (9*6); 54