Hi,

I'm having difficulty with how to compose a formula. This is the dilemma:

I have drop down lists and a Total box. The total box represents a sum. From this, I want a field to populate with the name an element.

Let's say, the sum is in cell O40. I want to say, "Anything <4" will be populated in F174 with an element of "Continual Learning" but if the sum is >4, "I don't want anything" populated in F174.

How do I put this in a formula?