Formula for value bands

[PhilipeC]

[h=2]Calculate a cell with set of rules[/h]

I want a formula to calculate K8 with these set of rules:


If C8 is 0 to 25 than K8 = "Very small"
If C8 is 26 to 35 than K8 = "Small"
If C8 is 36 to 45 than K8 = "Large"
If C8 is greater than 45 than K8 = "Very Large"​

 

[arthurbr]

Re: I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Ver

Try the LOOKUP function syntax#1

 

[Robby19]

Re: I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Ver

Try this;

=IF(AND(C8>=0,C8<=25),"Very Small",IF(AND(C8>=26,C8<=35),"Small",IF(AND(C8>=36,C8<=45),"Large",IF(C8>=46,"Very Large",""))))

 

[AlanY]

Re: I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Ver

the lookup() alternative

=LOOKUP(C8,{0,26,36,46},{"Very Small","Small","Large","Very Large"})

 

[Macropod]

Re: I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Ver

Duplicate of: https://www.mrexcel.com/forum/excel-questions/1054877-calculate-cell-set-rules-post5065449.html
As per Forum Rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html), kindly don't start multiple threads on the same topic.
Thread closed.