• 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. K

    INDIRECT function not returning cell value instead of cell formula

    I think the difference from 2002 to 2010 must have caused some formatting issues. I did two things. First, I changed the formula to an IF statement inside of an IF statement, instead of using the AND statement. (This may have been unnecessary if I had done the second thing first). Second...
  2. K

    INDIRECT function not returning cell value instead of cell formula

    I'm still in process on this. But, I was looking over the properties of the file, which was created before I came to this company. I am currently working with Excel 2010 on my computer. However, this file is based on a template that was originally created in 2002. Based on the functions I am...
  3. K

    INDIRECT function not returning cell value instead of cell formula

    Luke, I prepared a small sample worksheet to post for you. I lost my way, . . . , how do I send the worksheet?
  4. K

    INDIRECT function not returning cell value instead of cell formula

    This seems like it should be an easy answer but I've been struggling with it for a while. I haven't been able to see that anyone else addressed it. I have the following formula: =IF(AND(V147="YES",V137<0),-V137+(V104+V105+V108+V109+V135)+(V117+V118+V119+V120+V121+V122)+(V125+V126),0)...
Back
Top