Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Ifiserror problem

    Hi

    I am trying to add an iserror to this formula =IF(J24<>0,J24*B24,"") without success can anyone help please

    I am using excel 2010

    Many Thanks
    If you are a fool at forty, you will always be a fool

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,731
    Thanks
    395
    Thanked 1,533 Times in 1,390 Posts
    Not knowing what you logic requirements are for the error condition you can try this or adjust as appropriate.
    =IF(J24<>0,IF(ISERROR(J24*B24),"Calculation Error",J24*B24),"")
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,303
    Thanks
    3
    Thanked 206 Times in 190 Posts
    For 2010 you can use IFERROR:

    =IFERROR(IF(J24<>0,J24*B24,""),"Error message")
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Hi Guys

    Thanks for the prompt reply, this works for me
    Regards
    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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