Nested if (3 arguments help/pointers/guidance)

[Dan88]

Hello, I am hoping someone would be kind enough to help me guide through modifications of my nested if formula. Im pretty sure its a small adjustment im missing.
In short, i need it to look up 2 values and return certain results.

if B2="hard" and if BP2<30 then look up BO as like Lookup(BO2,{0,30,60,120,121}) {.95,.85,.75,.65} and if BP > 30 then lookup(bp2{30,120,121},{.65,.6,.5)))

So the first part of my formula looks like this =iferror(if(b2="hard", if(BP2<30, lookup(BO2,{0,30,60,120,121},{.95,.85,.75,.65}, lookup(BP2,{30,120,121},{.65,.60,.50}))

I am having trouble coupling this with another argument such that if B2 does not equal "hard" but "soft" then i need it to do this instead:
If BP2<60, then lookup(B02{0,45,90,120},{0.85,.8,.7,0})) otherwise 0

Can some be so kind to help me join these formulas or point me in right direction?

Thanks so much

 

[Fluff]

Maybe

=IFERROR(IF(B2="hard", IF(BP2<30, LOOKUP(BO2,{0,30,60,120,121},{0.95,0.85,0.75,0.65}), LOOKUP(BP2,{30,120,121},{0.65,0.6,0.5})),IF(B92<60,LOOKUP(B2,{0,45,90,120},{0.85,0.8,0.7,0}),0)),"")

 

[Dan88]

FLUFF, YOU ARE AMAZING. Thanks!! That worked as excected!

Thanks so much.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Dan88]

You're welcome & thanks for the feedback.

Hello, another challenging question for the pros if you can help me figure this out:
the below test works work for me:
iferror(if(b2="brid",if(c2="y", if(bq2<30,lookup(bp2,{0,60,90,120,180},{.9,.8,.6,.5,0}), lookup(bq2,{30},{0}))),lookup(bq2,{0,60,90,180},{.8,.7,.6,.5})))),"CHECK")

How can i add another nested if statement that will lookup if(b2="REN",if(c2="y"if(bq2<30,lookup(bp2,{0,60,90,120,180},{.9,.8,.6,.5,0}), lookup(bq2,{30},{0}))),lookup(bq2,{0,60,90,180},{.8,.7,.6,.5})))),"CHECK")

I need the answers in B2 to drive what i want on the cell. I got it to work for BRID, but dont know how to combine another iF that would work for REN.

ANY guidance is much appreciated.

THANKS ALL!

 

[Fluff]

How about

=IFERROR(IF(OR(B2={"brid","Ren"}),IF(C2="y", IF(BQ2<30,LOOKUP(BP2,{0,60,90,120,180},{0.9,0.8,0.6,0.5,0}), LOOKUP(BQ2,{30},{0})),LOOKUP(BQ2,{0,60,90,180},{0.8,0.7,0.6,0.5}))),"CHECK")

 

[Dan88]

Professor Fluff, you remain a rockstar. That worked as expected.

Thanks for your guidance and most importantly your time!

 

[Fluff]

Glad to help & thanks for the feedback.