Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Where is my hammer? I'll fix this problem.(Formula) (Resolve

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    East Texas
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can someone help me with the following problem? It has been eating my lunch for the past couple of days.

    In J10 I have =J9+I10 I need this to only work if I9 is >0 otherwise it would show the value of J9. I10 also has a formula of =IF(V10-V9 <0, "0", V10-V9).

    Thanks in Advance.

    Thanks for all the help

    [ This Message was edited by: Skyhook on 2002-05-13 06:42 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,033
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    In J10 I have =J9+I10 I need this to only work if I9 is >0 otherwise it would show the value of J9. I10 also has a formula of =IF(V10-V9 <0, "0", V10-V9

    In J10 enter:

    =SUM(J9,(I9>0)*I10)

    Change your formula in I10 to:

    =MAX(0,V10-V9)

    IF is not always the best thing to use .

    Aladin


    [ This Message was edited by: Aladin Akyurek on 2002-05-11 09:56 ]

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Skyhook, (with respect for Aladin's post), here's another option for future reference-

    =IF(I9>0,SUM(J9,I10),J9)

Some videos you may like

User Tag List

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
  •