• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    IFERROR problem

    Agreed :)
  2. S

    IFERROR problem

    You may also be able to use: IFERROR(Value if no error, value if error) for example: IFERROR(SUM(($N115+$N116)/$N120)*$J114,0)
  3. S

    excel formula to subtract text format date\time

    Hi Ikhan Your formula is correct. The problem is that the dates you are seeing are just text and not dates that Excel can perform a calculation with. When you try to add or subtract text you get the #VALUE error. To fix this, you will need to re-enter your dates. Excel will convert your dates...
Back
Top