+ Reply to Thread
Results 1 to 4 of 4

Additional calculation using an IF statement

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    114

    Additional calculation using an IF statement

    Hello all -

    I am trying to create a job aid for my company and having and unable to figure out how to make a calculation work.

    Based on the attached spreadsheet, what I am trying to do is create a message whether an insurance policy is enough to cover 20% value.
    Based on the area highlighted in Orange, what I have so far in terms of a formula is - =IF(C6=0,"",(IF(C6>D6,"Coverage is Adequate. Ok to Proceed.",(IF(C6<D6,"Falls outside of company guidelines. HO-6 policy needs to be increased by….."))))).

    The purpose of this part of the spreadsheet is that if the coverage of the flood is enough, it will say the "Coverage is adequate. Ok to Proceed".
    or, if the coverage is not adequate, the message will currently say - "Falls outside of company guidelines. HO-6 policy needs to be increased by....."
    After the word "by", I would like a formula to calculate the difference between cell d6 from c6 and generate a number telling the employee how much they are short.

    I have the basic formula for if "the coverage is ok". But when the coverage is not, having an issue creating the formula within the overall "If" formula to calculate and generate the calculation.

    Thank you all.
    Dave
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,576

    Re: Additional calculation using an IF statement

    Hi,
    perhaps try this....
    =IF(C6=0,"",(IF(C6>D6,"Coverage is Adequate. Ok to Proceed.",(IF(C6<D6,"Falls outside of company guidelines. HO-6 policy needs to be increased by"&" "&TEXT($B$12,"$0,0"))))))

  3. #3
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    114

    Re: Additional calculation using an IF statement

    Belinda - works perfectly.
    Thank you.
    Dave

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,576

    Re: Additional calculation using an IF statement

    you're welcome Dave.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Batch add additional calculation to a function while maintaining cell
    By lithos_g in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-03-2020, 07:59 AM
  2. [SOLVED] Additional calculation providing both conditions are met
    By Alfie092 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2020, 10:25 AM
  3. Please help me to add an additional IF statement into this code.
    By PistachioPedro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2019, 02:57 AM
  4. Calculate Between Two Times With Additional If Calculation
    By StokieWorm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2017, 09:24 AM
  5. [SOLVED] Additional IF Statement - Help!
    By mack_76 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2015, 07:06 AM
  6. Adding additional IF statement
    By rhudgins in forum Excel General
    Replies: 1
    Last Post: 04-13-2010, 04:59 PM
  7. [SOLVED] additional month calculation
    By BorisS in forum Excel General
    Replies: 6
    Last Post: 12-13-2005, 02:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1