IF & Nested IF Function Insurance Premiums with multiple conditions

[maynardc]

I am needing assistance with creating a formula to produce the correct Insurance Premiums.

See the attached.

@Ingeborg Hawighorst

@Sergei Baklan

[#2 · Accepted solution]

@maynardc 

Please find the attached and let me know if the formula implemented in yellow cells are returning the desired output as per the conditions you specified.

[#3]

@Subodh_Tiwari_sktneer 

Thank you for your quick and accurate response, it is greatly appreciated!!!

[#4]

@maynardc 

You're welcome! Glad it worked as desired.