+ Reply to Thread
Results 1 to 3 of 3

Formula Question:How do you automatically calculate information

  1. #1
    Formula Question
    Guest

    Formula Question:How do you automatically calculate information

    How do you automatically calculate information in unhidden cells that contain
    a formula to calculate from another spreadsheet that shows data and hidden
    cells that have a formula to calculate from another spreadsheet that returns
    a Div/0! because data is unavailable without the formula result being Div/0!
    because the hidden cells do not contain any data?

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    It's probably best to suppress the errors in the first place. If you have a formula like

    =A1/B1 which gives a #DIV/0! error then you can change to

    =IF(B1,A1/B1,"")

    alternatively you can sum a range, say C1:C10, and ignore #DIV/0! errors with

    =SUMIF(C1:C10,"<>#DIV/0!")

  3. #3
    edcosoft@sbcglobal.net
    Guest

    re: Formula Question:How do you automatically calculate information

    In your final worksheet use, IF(ISNUMBER(A1),A1,""), or
    IF(ISERROR(A1),"",A1). ed


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1