Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: formula question

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi group,

    To avoid the #DIV/0! i use :

    =If(C23=0,0,G23/C23) but it doesn't work with

    =If(H23,0,0,F23/H23-1) i know the glitch is
    with the minus 1 "H23-1" any ideas on how to get around this

    thanks
    James


  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 20:54, James wrote:
    Hi group,

    To avoid the #DIV/0! i use :

    =If(C23=0,0,G23/C23) but it doesn't work with

    =If(H23,0,0,F23/H23-1) i know the glitch is
    with the minus 1 "H23-1" any ideas on how to get around this

    thanks
    James
    Hi James :
    It is not clear what are the arguments in your second formula ... Did you mean your second formula to be ...

    =IF((H23-1)=0,0,F23/(H23-1))

    Please post back if it works for you ... otherwise explain a little further and let us take it from there!


    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Very good Yogi,

    This seems to do it:

    =If((H7-1)=0,0,F7/H7-1)

    Thanks
    James

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No, it's still returning the #DIV/0! ???

    James

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No, it's still returning the #DIV/0! ???

    James

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 21:07, James wrote:
    Very good Yogi,

    This seems to do it:

    =If((H7-1)=0,0,F7/H7-1)

    Thanks
    James
    Hi James:
    Once more slow down and be patient ... I think you meant to post the following formula:
    =If((H7-1)=0,0,F7/(H7-1))

    Regards!

    Yogi Anand

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yogi...
    I think you pinned that one on the head!
    well done!

  8. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 21:15, Qroozn wrote:
    Yogi...
    I think you pinned that one on the head!
    well done!
    Hi Qroozn:
    I got the drift of what you were trying to say to gideon, so on tonite's watch you be the tough guy and I'll be the softie.

    Regards!

    Yogi Anand

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again Yogi,

    Cell F7 "0.03"
    Cell G7 "5.45"
    Cell H7=G7/C7 "0.011"
    But when G7 is empty
    Cell J7 is returning the #DIV/0!

    Any thoughts

    James

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =If(Or((H7-1)=0,g7=0),0,F7/(H7-1))

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
  •