Need help with Multiple Condition formula

[Prakash M]

Hello,

I have a below formula, in which I need to have one more logic.

=IF(A2="Yes",IF(B2>=115,"POST",IF(B2>=76,"Green",IF(B2<76,"Blue",IF(AND(B2>0,H40<60),"Orange",IF(C2>=60,"Blue"))))),"Not Started")

A column is a Status column with Yes and No drop down
B column is a Rank column
C Column is a Average column

I would like to add one more logic, if Status is No and Average in less than 60, than "Ready to Launch" else "Closed"

 

[p45cal]

Cell E2:
=IF(A2="Yes",IF(B2>=115,"POST",IF(B2>=76,"Green",IF(B2<76,"Blue",IF(AND(B2>0,H40??<60),"Orange",IF(C2>=60,"Blue"))))),"Not Started")

 

[Prakash M]

Oh my bad. Instead of H40, it should be C2

=IF(A2="Yes",IF(B2>=115,"POST",IF(B2>=76,"Green",IF(B2<76,"Blue",IF(AND(B2>0,H40??<60),"Orange",IF(C2>=60,"Blue"))))),"Not Started")