Value used in the formula is of the wrong data set.
Attend Excelapalooza
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Value used in the formula is of the wrong data set.

  1. #1
    New Member
    Join Date
    Oct 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Value used in the formula is of the wrong data set.

     
    I have the following formula: =IF(AP32*AQ32*AR32*AS32>0,"Y","N")

    I am creating a spreadsheet that gives results on a monthly basis and on a Quarterly basis. Under the quarterly basis I am getting the valued used error only on the columns that are blank. Not sure why this is happening only under the Quarterly and not monthly. It needs to return a Y if all the columns have numbers, if not then it needs to return an N


    Not sure where the issue is. Help Thank you

  2. #2
    Board Regular iggydarsa's Avatar
    Join Date
    Jun 2005
    Location
    One of the Blue States
    Posts
    1,637
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Value used in the formula is of the wrong data set.

    would something like this work?
    =IF(AND(ISNUMBER(A1), ISNUMBER(A2),...), "Y", "N")

  3. #3
    Board Regular
    Join Date
    May 2017
    Location
    Boston
    Posts
    733
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Value used in the formula is of the wrong data set.

    Try this:

    Code:
    =IF(ISNA(MATCH("",AP32:AS32,0)),"Y","N")
    or this:

    Code:
    =IF(COUNTIF(AP32:AS32,">0")=4,"Y","N")
    Last edited by ErikTyler; Dec 7th, 2017 at 01:38 PM.

  4. #4
    New Member
    Join Date
    Oct 2017
    Posts
    9
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Value used in the formula is of the wrong data set.

    Thank you the =IF(COUNTIF(AP32:AS32,">0")=4,"Y","N") is the one that worked. I appreciate the help.

  5. #5
    Board Regular
    Join Date
    May 2017
    Location
    Boston
    Posts
    733
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Value used in the formula is of the wrong data set.

      
    @gperez1127, glad you found one that fit your specific needs.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com