Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,952
    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,958
    Thanks
    422
    Thanked 1,606 Times in 1,450 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,349
    Thanks
    4
    Thanked 228 Times in 210 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,952
    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
  •