Results 1 to 8 of 8

Thread: Simple Fx using addition leads to #VALUE result and I don't know why...

  1. #1
    New Member
    Join Date
    Jun 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Simple Fx using addition leads to #VALUE result and I don't know why...

    (Excel for Mac 2013) I'm sure there is a simple solution:

    I am adding up every other cell in a horizontal row (A1+C1+E1+G1+I1) and totaling the numbers in these cells in cell K1.

    In cell C1, there is an =IF(AND fx that results an integer, but when I add cells A1+C1+E1+G1+I1, the fx result in C1 is creating a "#VALUE" response in cell K1 rather than a sum of the numbers in the 5 aforementioned cells.

    I've tried changing the format of the cells to 'General' and 'Number'...etc. but nothing is working.

    Any ideas?

    Thanks in advance.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    225
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    What is the formula in C1?
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    New Member
    Join Date
    Jun 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    =if(and(q8<-2.88,q8>-6.9,r8<16.3,r8>-10,d8<-5.5,d8>-11),1,"")

  4. #4
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    225
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    Change that last "" to 0
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  5. #5
    New Member
    Join Date
    Jun 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    Just tried it. Unfortunately, it didn't work.

    Any other ideas?

  6. #6
    Board Regular
    Join Date
    Sep 2012
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    Quote Originally Posted by brose99 View Post
    Just tried it. Unfortunately, it didn't work.

    Any other ideas?
    Are the numbers in cells D8 and/or Q8 and/or R8 perhaps entered as text values?

  7. #7
    New Member
    Join Date
    Jun 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    NAILED IT! Thanks petertenthije and Toadstool!!

  8. #8
    New Member
    Join Date
    Jun 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple Fx using addition leads to #VALUE result and I don't know why...

    Solved

Some videos you may like

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
  •