Results 1 to 4 of 4

Using And/If/Or Formulas Functions

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Using And/If/Or Formulas Functions

    Hello All,

    I am trying to figure out how to go about making a formula function that can come up with the following to the attached file and grab the sales volume only of the below criterias:

    1) If Days to Good (Column 'R') is "<=30" OR Type Code (Column 'P') is "P" AND Total DP Perc (Column 'AK') is ">=0.1" OR Days to Good (Column 'R') "<30" AND Total DP Perc (Column 'AK') ">=.10" AND Status (Column 'U') is not (X,T) - Then calculate sales volume (Column 'H') if not then 0

    and

    2) If Days to good (Column 'R') is between 31 and 60 AND Total DP Perc (Column 'AK') is "<.10" AND Status (Column 'U') is not (X,T) then calculate Sales Volume (Column 'H'), if not then 0

    Thanks so much for your help!

    Hendrix P.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. what functions/formulas to use
    By le3 in forum Excel General
    Replies: 1
    Last Post: 04-05-2007, 03:42 PM
  2. functions/formulas
    By Lara Leigh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2006, 11:20 PM
  3. Using formulas/functions
    By Lucylambkin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-11-2005, 12:50 PM
  4. [SOLVED] functions/formulas
    By AccountantPB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2005, 11:06 PM
  5. [SOLVED] Functions and formulas
    By abfabrob in forum Excel General
    Replies: 4
    Last Post: 04-13-2005, 04:06 PM

Tags for this Thread

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