HELP WITH IF THAN GREATER THAN, MULTIPLE SCENARIOS

[Meanes1992]

I am really struggling with the formulas for one particular cell.

What i'm looking for is the value in B17 will be determined as Followed. I'm hoping someone can help my brain wrap around this

IF b15 is less than 50, then b19= "Product A"
IF b15 is greater than 50, and less than 250, then b19= "product B"
IF B15 is greater than 250, then b19 = "Product C"

if C16 is YES, then b19 = "product D"
IF C17 is YES, then b19 = "Product E"

Is this even feasible?

 

[Fluff]

Hi & welcome to MrExcel.
At what point does the criteria re C16 & C17 kick in?

 

[Meanes1992]

Hi & welcome to MrExcel.
At what point does the criteria re C16 & C17 kick in?

C16 and C17 should have priority over the B15. Truthfully i'm okay removing the C16 & C17 portion of this.
Rather i just need to be able to put the following into one formula.

=IF(AND(B15>50,B15<250),"Simply Business 250")

=IF(B15<50,"Simply Business 50")

=IF(B15>250, “Simply Business 500”)

 

[Fluff]

Ok, how about

=IF(B15<50,"A",IF(B15<250,"B","C"))

 

[Meanes1992]

Ok, how about

=IF(B15<50,"A",IF(B15<250,"B","C"))

Dear lord, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.