+ Reply to Thread
Results 1 to 7 of 7

Formulas giving unexpected errors

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    13

    Formulas giving unexpected errors

    Hey all,

    A while back you guys helped me start a spread sheet for work, in which I'm still eternally grateful!

    Now, I've added a few things to fine tune it to how I need it to work. But, I'm hoping that one of you gurus will look it over and dot the i's and such.

    I'm getting a few small errors. In particular is the area of R/T 3-8. And F25.

    I really appreciate all you guys help more than you can possibly know.

    Thank you!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-24-2014
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formulas giving unexpected errors

    In R5 instead of
    =T3+T4

    use
    = Sum(T3,T4)

  3. #3
    Registered User
    Join Date
    06-27-2014
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    13

    Re: Formulas giving unexpected errors

    That helped! Thanks!

    I'm still getting the error on F25 though. Can't seem to shake it.
    Last edited by Nifty62; 08-25-2014 at 01:19 AM.

  4. #4
    Registered User
    Join Date
    08-24-2014
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formulas giving unexpected errors

    if R5 is not giving error, then F25 is also not giving error.

    did you make any changes to the file, formula ?
    if so pls upload new file.

  5. #5
    Registered User
    Join Date
    06-27-2014
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    13

    Re: Formulas giving unexpected errors

    Nvm, false alarm. I was looking at an old version of the sheet on my tablet.

    But now, when I try to select N19 on the tablet, it says something like "unable to edit array."

  6. #6
    Registered User
    Join Date
    06-27-2014
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    13

    Re: Formulas giving unexpected errors

    Ok, I've done quite a bit of work on the sheet and I think it's looking pretty good.

    Any final thoughts?
    Attached Files Attached Files
    Last edited by Nifty62; 08-26-2014 at 10:52 PM.

  7. #7
    Registered User
    Join Date
    08-24-2014
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formulas giving unexpected errors

    you have locked the cells which contains formulas.. that is a good practice.
    Your formula giving error was simple.
    BUT in future - if your formula gives error result & you want to ignore the error - there are formula like IFERROR, IFNUMBER, etc..


    can i ask for "Add Reputation" -- click star
    ☚ Don't forget to rate person who helped u Click ★

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple If-Then test giving unexpected results
    By CM1227 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2014, 04:00 PM
  2. Simple If-Then test giving unexpected results
    By CM1227 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2014, 10:18 AM
  3. Formula giving unexpected results
    By johnmerlino in forum Excel General
    Replies: 6
    Last Post: 12-01-2010, 01:20 AM
  4. Autofilter giving unexpected results!
    By Colin Vicary in forum Excel General
    Replies: 3
    Last Post: 09-28-2006, 07:20 AM
  5. Equation giving unexpected results
    By Mike K in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-27-2005, 11:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1