+ Reply to Thread
Results 1 to 2 of 2

Determine value based on whether a customer name is in a list

  1. #1
    Registered User
    Join Date
    09-11-2016
    Location
    Australia
    MS-Off Ver
    Microsoft 365
    Posts
    89

    Determine value based on whether a customer name is in a list

    I have two columns - one with customer name (A1), another with a number (B1)

    What I want is, IF A1 equals a specific Customer name taken from a list, then return 14 in B1 (Being the number of days they have to pay), otherwise it just returns a 7.

    Currently my formula is =IF(A1="Customer1","14","7") Which is great, but only allows for one customer. I need it to do the formula, but if A1 contains a name from a list of names then returns 14 otherwise it is 7. I can put the list on a different tab.

    Please help!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2405
    Posts
    25,004

    Re: IF Function Help Please

    Let's just imagine that your list of names is in column C, and that's all that's in column C.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Also, do not put numbers in quotes.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Formula to separate rows in a customer list based on Zip Code.
    By AIceStL in forum Excel General
    Replies: 5
    Last Post: 02-25-2020, 06:00 PM
  2. Generate a separate staff customer list based on larger customer table
    By CARROLLJP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2018, 04:40 PM
  3. [SOLVED] Formula to determine monthly cash flow based on customer contract length
    By Wedge120 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2013, 08:42 PM
  4. sorting a list of customer invoices from columns into rows / customer
    By jr1984 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2011, 07:04 AM
  5. Replies: 0
    Last Post: 04-01-2011, 12:10 PM
  6. [SOLVED] Return a price based on a customer from a drop down list
    By Pete Elbert in forum Excel General
    Replies: 7
    Last Post: 04-30-2006, 10:00 PM
  7. How To Make A Customer List With Extra Entries Per Customer
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2005, 03:43 PM

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