Nested if 3 conditions

[Dan88]

Hello, can you please help point me in the right direction on this formula.

Basically it has 3 conditions depending on day count.

If <60 it should return “80%”
If >60 but under 180 it should return 75%
And if over 180 it should return 65%


I am trying this but it wont work.:

=IF(A3<=60,"80%",IF(AND(A3>=60,A3<=180,"75%"),IF(A3>=180,"65%")))

Any help or pointers would be greatly appreciated. Thanks!

 

[Fluff]

How about
=IF(H3="RL",IF(AC3>50%,LOOKUP(AE3,{0,60,180},{0.8,0.75,0.65}),LOOKUP(AE3,{0,60,180},{0.55,0.65,0.75})),"Not rl")

 

[Dan88]

Fluff, amazing. thank you 10000x!
Thanks everyone on MREXCEL.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Dan88]

Hello All. Hope the EXCEL community is doing well.

I have a quick question on this lookup formula if anyone can give me some guidance.
I am repurposing the formula the forum assisted me back in OCT but need it to do 1 thing.

Currently i am using this:

LOOKUP(BO2,{0,30,60},{0.95,0.85,0.75}) I also need to combine or string this to lookup value in BP2 such that if BP2: 0 - 30 keep above formula 30 - 60 ignore the above and use .35 60 - 120 value should be .30 120+ value should be .25 I tried to use string two lookups but its not working. Thanks in advance for any guidance.

 

[Fluff]

Please start a new thread for this. Thanks.