+ Reply to Thread
Results 1 to 2 of 2

Need assistance with IF function formula

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    Houston, USA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Need assistance with IF function formula

    Hopefully someone can resolve an issue I have with an IF function formula.

    I have attached a file with a a copy of the formula I am currently using (col L) plus the associated conditions. The issue I am having is trying to figure how to exclude a value in column N from the calculation in all cases, even if some of the conditions in the formula permit an answer to appear in column L. (Column I is system generated, and column L validates the result).

    The current formula works 90% of the time. It is trying to resolve the issue with the final 10% that is giving me headaches. Also any suggestions for improvements/alternatives would be greatfully received.

    rgds,
    Cymraeg
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need assistance with IF function formula

    maybe..

    =IF(C3="Post-Life",0,IF(C3="Pre-Close",O3*B3,IF(C3="Post-Close",IF(AND(F3>=1,F3<=48,SUM(G3:H3)>0),P3*B3,0))))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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