Calculating From A Range

[ithoughtiknewit]

Help! Maybe I am overthinking this. D5 has an =sum calculation. If it returns between 1 and 20 I need D6 to show 1. If it returns between 21-30 then D6 returns 2 and so on with different ranges. Only about 5 total with the last being greater then 100 returns 5.

 

[Fluff]

One option would be like

=IF(D5<=20,1,IF(D5<=30,2,IF(D5<=40,3,4)))

alternatively you could setup a lookup table & use vlookup