+ Reply to Thread
Results 1 to 3 of 3

Inexplicable Formula Alerts

  1. #1
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    259

    Inexplicable Formula Alerts

    Good day, Gurus,

    In the sample data I've attached, on the Summary tab, you'll notice in cells K2-6, I'm seeing an alert that "the formula in [these] cell[s] refers to a range that has additional numbers adjacent to it." However, it's performing exactly as intended, but stranger still, the formula is identical in syntax to every cell below them (K7-23) for which I'm not seeing any such alert. It doesn't appear to be affecting anything, but I am curious why the alerts for only these specific cells, and further concerned it might be affecting something I'm unaware of. Any thoughts?

    Thanks in advance for any help anyone might provide.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Inexplicable Formula Alerts

    I can reproduce the alerts, but I have my options set to turn them off. I had to turn them back on to examine your file.

    It is just a warning that your average starts in column C but you have data in columns A and B that you might be missing. I don't know why the alerts do not continue all the way down column K.

    You can safely ignore these warnings, or do like I do and just turn them off altogether.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    259

    Re: Inexplicable Formula Alerts

    Alright; thank you, sir! I'd give you rep, but apparently, you're the last person I gave rep to, and the site won't let me!
    Last edited by AliGW; 07-06-2023 at 09:35 AM. Reason: Please do NOT quote unnecessarily!

+ 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. Pop Up - Reminder Alerts Formula Help
    By hayles831 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2022, 12:46 PM
  2. Formula for date alerts
    By EmmaBcrown in forum Excel General
    Replies: 4
    Last Post: 11-24-2020, 12:34 PM
  3. Alerts when value change in cell from a formula
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2020, 11:47 AM
  4. [SOLVED] Array formula to show two alerts?
    By Margate in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2016, 11:53 AM
  5. Inexplicable Redim error
    By PeterWilliams in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-07-2007, 08:48 PM
  6. Date Formula & Alerts
    By Kidtick7609 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2007, 04:18 PM
  7. Inexplicable 400 error
    By mzza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2006, 11:53 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