Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: #Div/0! - need to change to a meaningful message

    Hi,
    I have a formula that calculates percent as (A+B/C). Sometimes C=0 and I get this #Div/0! displayed on the report. How can I replace #Div/0! with "C=0" to inform the reader?
    Mo

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    Iif(c = 0, "message", (A+B)/C)...
    Note that your results are all strings now.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    Worked great. Thanks a lot.
    Mo

Posting Permissions

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