Calculate a cell with set of rules

[PhilipeC]

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"

 

[Legacy 143009]

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"

=IF(C8<26,"Very Small",IF(C8<36,"Small",IF(C8<46,"Large","Very Large")))

Have a nice day

 

[Macropod]

Duplicate of: https://www.mrexcel.com/forum/excel...-than-k8-very-la-post5065456.html#post5065456
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.

 

[Michael M]

slow learner ???...