+ Reply to Thread
Results 1 to 8 of 8

Getting "Inconsistent Formula" and don't know why

  1. #1
    Registered User
    Join Date
    06-03-2018
    Location
    Nova Scotia, Canada
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13231.20110) 32-bit
    Posts
    8

    Getting "Inconsistent Formula" and don't know why

    I'm getting an "Inconsistent Formula" error, and can't figure out why. If you open the attached sheet, you'll see that the error goes away when I insert a blank column after the column with the error. I don't understand why a blank column fixes it; it seems unnecessary.
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Getting "Inconsistent Formula" and don't know why

    When you have a row of (three or more) formulas, Excel thinks they should be the same, not vary by column.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-03-2018
    Location
    Nova Scotia, Canada
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13231.20110) 32-bit
    Posts
    8

    Re: Getting "Inconsistent Formula" and don't know why

    Quote Originally Posted by shg View Post
    When you have a row of (three or more) formulas, Excel thinks they should be the same, not vary by column.
    Interesting. So a blank column between them makes Excel think it's a new row? That's interesting as well, lol.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Getting "Inconsistent Formula" and don't know why

    No, it separates the formulas unto pairs, not three adjacent.

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,955

    Re: Getting "Inconsistent Formula" and don't know why

    I don't see anything inconsistent.

    Your G8 Sum formula is including G5:G7 and not F5:F7 which it should do if you want to be consistent.

    But why not jus use

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in G8
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  6. #6
    Valued Forum Contributor
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    1,065

    Re: Getting "Inconsistent Formula" and don't know why

    Hi
    Incosistent formula is not really an error, it's just a warning. It will still give you the result you are looking for.
    The empty column "interrupts" the array of formulas, so the notice will disappear.

  7. #7
    Registered User
    Join Date
    06-03-2018
    Location
    Nova Scotia, Canada
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13231.20110) 32-bit
    Posts
    8

    Re: Getting "Inconsistent Formula" and don't know why

    Quote Originally Posted by Richard Buttrey View Post
    I don't see anything inconsistent.

    Your G8 Sum formula is including G5:G7 and not F5:F7 which it should do if you want to be consistent.
    hmmm.... that G5:G7 might have been a brain fart when creating the sample sheet. But I'll definitely check the actual sheet to make sure. Good catch!


    Quote Originally Posted by Richard Buttrey View Post

    But why not jus use

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in G8
    I would if it were just a few rows like the sample. The actual sheet has more rows, so I keep the formula short. Unless there's a reason not to? (I'm relatively new to using formulas)

  8. #8
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,955

    Re: Getting "Inconsistent Formula" and don't know why

    Quote Originally Posted by Joel. View Post
    hmmm.... that G5:G7 might have been a brain fart when creating the sample sheet. But I'll definitely check the actual sheet to make sure. Good catch!



    I would if it were just a few rows like the sample. The actual sheet has more rows, so I keep the formula short. Unless there's a reason not to? (I'm relatively new to using formulas)
    But the formula I suggested is shorter than your original so I don't understand your comment above.

+ 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] Brief formula to convert time values to "shift1", "shift2", "shift3".
    By darekpawel in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-11-2019, 07:05 AM
  2. Dynamic Table Auto Fill Help "Inconsistent Calculated Column Formula"
    By GMAGANA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-02-2012, 12:03 PM
  3. Replies: 1
    Last Post: 05-08-2012, 09:36 AM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. Replies: 12
    Last Post: 07-14-2010, 10:39 AM
  6. "inconsistent formula" error!
    By grannygamer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2007, 03:33 AM
  7. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 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