Rather than using (IFs) Function

[Dr. AHMED Al-Wasity]

Hi Rather than using (ifs) function, I need an optimum way or function to return the value of P based on the values of sum (B8:B15) and values of (F6,F7,H6,H7 and J6) such that: 1. if sum>=H7 , P=P5, 2. if F7≤sum<H7, P=P4, 3. if J6≤sum<F7 P=P3, 4. if H6≤sum<J6, P=P2, 5. if F6≤sum<H6, P=P1, 6. if sum<F6, P="".

Please consider this google Sheet. Thanks

[Brent Guttmann]

Could you elaborate on the specific use case for this? I didn’t fully follow the requirements during my quick look at it, and I don’t have the time to sort through it in detail. Providing an example and the relevant data might help me better understand what you’re aiming to achieve.