IF Statements Trouble

[scotty1978]

Trying to create an IF formula which is a little tricky, hoping to get some help.

Here are conditions:

IF B2*1 is less than or equal to D2 , then show Text D2. If B2*1 is greater than or equal to D2, then show Text D3. If B2*1 is greater than or equal to B4, then show Text D4.

The formula will then repeat itself below B2*2, B2*3, B2*4 in the corresponding cells below down the line. I'm not too concerned about that. If there is a formula that works for the example above, I can make those adjustments.

Thanks in advance

 

[scotty1978]

StephenCrump, I got this to work by removing *n in the first condition. It now works exactly the way I need it. I really appreciate all your help.

 

[StephenCrump]

You're welcome. I'm glad you got it working the way you want.