Results 1 to 4 of 4

Thread: formula help

  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    =IF(K3>0,I3&" Points - Up "&SUM(P3-J3)&" Places",IF(I3&" Points - Down "&SUM(J3-P3)&" Places",I3&" Points - No Movement"))

    Can anyone see why I am getting a #value error?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The second IF does not have a condition - perhaps you intended to have

    K3<0,

    after the second IF(

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I presume that K3 is <=0, since that will lead to the error. If K3<=0 then you get the following statement:

    IF(I3&" Points - Down "&SUM(J3-P3)&" Places",I3&" Points - No Movement")

    The first part of the statement is the condition to test which is:
    =I3&" Points - Down "&SUM(J3-P3)&" Places"

    This is TEXT and is not a number or TRUE or FALSE, so it gives the #VALUE error...

    What are you trying to achieve?
    Are you after:
    =IF(K3>0,I3&" Points - Up "&SUM(P3-J3)&" Places",IF(K3<0, I3&" Points - Down "&SUM(J3-P3)&" Places",I3&" Points - No Movement"))

    Steve

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks both, I think I was looking at it for too long and couldn't see the wood for the trees....

Posting Permissions

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