Forum Discussion

Copper Contributor

Sep 16, 2019

Solved

IF & Nested IF Function Insurance Premiums with multiple conditions

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

See the attached.

IngeborgHawighorst

IF Functions - problem items.xlsx12 KB

Formulas and Functions

Subodh_Tiwari_sktneer
Sep 16, 2019
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.

IF Functions - problem items.xlsx14 KB

3 Replies

Subodh_Tiwari_sktneer
Silver Contributor
Sep 16, 2019
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.

IF Functions - problem items.xlsx14 KB
- maynardc
  Copper Contributor
  Sep 16, 2019
  Subodh_Tiwari_sktneer
  Thank you for your quick and accurate response, it is greatly appreciated!!!
  - Subodh_Tiwari_sktneer
    Silver Contributor
    Sep 16, 2019
    maynardc
    You're welcome! Glad it worked as desired.