Jul 07 2022 07:51 AM
Hi, I am trying to merge a couple of formulas in my spreadsheet.
This is what I want
=if K2 = "Mainstream", IF(J2<18.5,(L2*0.75),(13.5*I2))
=if K2 = "Specialist/PRU" , IF(J2<47,(L2*0.75),(35.25*I2))
Mainstream and Specialist/PRU are the only options for cell K2 but they each come with their own costing calculations.
Can anybody please provide the formula for all of this to appear in one cell?
Many thanks :)
Jul 07 2022 11:53 AM
@Adele1981 Try this:
=IF(K2="Mainstream",IF(J2<18.5,(L2*0.75),(13.5*I2)),IF(J2<47,(L2*0.75),(35.25*I2)))
Jul 08 2022 12:21 AM