Consulting

Results 1 to 4 of 4

Thread: Formula with no error message?

  1. 12-06-2006, 02:54 PM #1
    apharrington
    apharrington is offline
    VBAX Regular
    Joined
    Dec 2006
    Posts
    14

    Formula with no error message?

    How would I write this formula to round without it displaying an error message if the cell is left blank?

    =IF(ISERROR(F17*H17),"",IF(F17=-1,H17,F17*H17))

    I tried:

    =ROUND(IF(ISERROR(F17*H17),"",IF(F17=-1,H17,F17*H17)),2)

    it returns #VALUE! if left blank.
    Reply With Quote Reply With Quote
  2. 12-06-2006, 03:02 PM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    =IF(ISERROR(F17*H17),"",ROUND(IF(F17=-1,H17,F17*H17)),2)
    Reply With Quote Reply With Quote
  3. 12-06-2006, 03:05 PM #3
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    I don't get an error with a blank cell, but I do if I enter text. Anyway, try

    =IF(ISERROR(F17*H17),"",IF(F17=-1,ROUND(H17,2),ROUND(F17*H17,2)))
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  4. 12-06-2006, 03:36 PM #4
    apharrington
    apharrington is offline
    VBAX Regular
    Joined
    Dec 2006
    Posts
    14

    THANK YOU!!!

    THANK YOU! THANK YOU!

    I love this site already!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules