Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2008
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In the attached spreadsheet, I'm attempting to use the ISERROR formula to hide various error messages. Similar to =IF(ISERROR(#VALUE!),"",SUM(U115/R115)). Now when I copy/paste that, for some reason all cells are getting blanked out and I can't figure it out. It might be the VLOOKUPS that are also in the workbook but I can't be sure. Any assistance would be appreciated.

    Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jun 2010
    Location
    philippines
    Posts
    185
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by aapke View Post
    In the attached spreadsheet, I'm attempting to use the ISERROR formula to hide various error messages. Similar to =IF(ISERROR(#VALUE!),"",SUM(U115/R115)). Now when I copy/paste that, for some reason all cells are getting blanked out and I can't figure it out. It might be the VLOOKUPS that are also in the workbook but I can't be sure. Any assistance would be appreciated.

    Thanks.
    your supposed to put a "value" on the (#VALUE!)say something liked this
    =IF(ISERROR(U115/R115),0,SUM(U115/R115))

  3. #3
    Lounger
    Join Date
    Jan 2008
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ah. Got it. Thank you.

  4. #4
    2 Star Lounger
    Join Date
    Jun 2010
    Location
    philippines
    Posts
    185
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by aapke View Post
    Ah. Got it. Thank you.
    np ENJOY

Posting Permissions

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