+ Reply to Thread
Results 1 to 4 of 4

Assign a point value to a response in another cell

  1. #1
    Registered User
    Join Date
    06-12-2017
    Location
    NH
    MS-Off Ver
    2016
    Posts
    1

    Assign a point value to a response in another cell

    I'm looking for the command that would allow me to assign a point value to a response in another cell. For instance, if you answer yes in one cell, the cell next to it would give you 10 points. If you said no, the next cell would show a zero....make sense?

    Can you advise the formula?

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Assign a point value to a response in another cell

    =if(a1="yes",10,if(a1="no",0,"")) if the values are being entered in A1

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Assign a point value to a response in another cell

    Hi Geot, welcome to the forum! If your response ("Y" or "N") is in cell B2, this formula in A2:
    =IF(B2="Y",10,0)

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Assign a point value to a response in another cell

    Hello Geot & Welcome to the Forum,

    Maybe try...

    =IF(A1<>"",LOOKUP(A1,{"No","Yes"},{0,10}),"")
    HTH
    Regards, Jeff

+ 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. Assign point values based on performance
    By nsrawlings in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2015, 07:40 AM
  2. Assign value associated with a point to a range
    By zxcity in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2013, 09:10 AM
  3. Assign point values to ranks
    By JustinN1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2013, 05:18 PM
  4. How to assign a value to a data point
    By Bill Brasky in forum Excel General
    Replies: 10
    Last Post: 09-05-2012, 03:57 PM
  5. How to assign a macro to a data point on chart
    By joeyj in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-06-2011, 09:57 AM
  6. Replies: 8
    Last Post: 07-30-2006, 07:35 AM
  7. How do I assign point values on survey answers?
    By MikeM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2006, 12:55 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