Current Formula:

=IF(SUM(C8:C14)>=8, "10", IF(SUM(C8:C14)=14, "10", IF(SUM(C8:C14)=12, "10", IF(SUM(C8:C14)=6, "6", IF(SUM(C8:C14)=4, "4", IF(SUM(C8:C14)=2, "2", IF(SUM(C8:C14)=0, "0",)))))))

Which WORKS (and is great) but due to its complexity, Google Sheets doesn't recognize the cell's total (displays "0") and therefore the entire sheet is off. Basically, I just need a formula that states 0=0, 2=2, 4=4, 6=6, 8=10, 10=10, 12=10, and 14=10.

CodePudding user response：

Make a table as follows

The formula will be

=vlookup(sum(C8:C14),F1:G8,2,1)

CodePudding user response：

How about a simple IF statement like this?

=IF(SUM(C8:C14)>=8, 10, SUM(C8:C14))