SOLVED
Home

IF & Nested IF Function Insurance Premiums with multiple conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-857367%22%20slang%3D%22en-US%22%3EIF%20%26amp%3B%20Nested%20IF%20Function%20Insurance%20Premiums%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857367%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20needing%20assistance%20with%20creating%20a%20formula%20to%20produce%20the%20correct%20Insurance%20Premiums.%3C%2FP%3E%3CP%3ESee%20the%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-857367%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857411%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%26amp%3B%20Nested%20IF%20Function%20Insurance%20Premiums%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857411%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409244%22%20target%3D%22_blank%22%3E%40maynardc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20the%20attached%20and%20let%20me%20know%20if%20the%20formula%20implemented%20in%20yellow%20cells%20are%20returning%20the%20desired%20output%20as%20per%20the%20conditions%20you%20specified.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857414%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%26amp%3B%20Nested%20IF%20Function%20Insurance%20Premiums%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20quick%20and%20accurate%20response%2C%20it%20is%20greatly%20appreciated!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857419%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%26amp%3B%20Nested%20IF%20Function%20Insurance%20Premiums%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857419%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409244%22%20target%3D%22_blank%22%3E%40maynardc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%20Glad%20it%20worked%20as%20desired.%3C%2FP%3E%3C%2FLINGO-BODY%3E
maynardc
Occasional Contributor

 

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

See the attached.

 

@Ingeborg Hawighorst

@Sergei Baklan

3 Replies
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.

 

 

@Subodh_Tiwari_sktneer 

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

@maynardc 

You're welcome! Glad it worked as desired.

Related Conversations
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Which formula to use
Ramon Haagen in Excel on
2 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies