+ Reply to Thread
Results 1 to 4 of 4

Unknown Formula Pause Error

  1. #1
    Registered User
    Join Date
    04-07-2022
    Location
    United States
    MS-Off Ver
    Google Sheets
    Posts
    3

    Question Unknown Formula Pause Error

    Edit: I've figured it out! was just missing some commas.

    Hi! can anyone help me understand why this formula is giving me a formula pause error? None of the cells I'm referencing contain errors. I'm at a complete loss here, from what I understand, this should work. Thanks!

    =IF($Q$117=1,AA221,
    "Total:" &LEFT(AB221,91)&
    IF(AY131=0,$A$265
    IF(AY131=1,$A$268
    IF(AY131=2,$A$271
    IF(AY131=3,$A$274)))) &MID(AB221,92,182)&
    IF(AY131=0,$A$266
    IF(AY131=1,$A$269
    IF(AY131=2,$A$272
    IF(AY131=3,$A$275)))) &MID(AB221,183,273)&
    IF(AY131=0,$A$267
    IF(AY131=1,$A$270
    IF(AY131=2,$A$273
    IF(AY131=3,$A$276)))) &RIGHT(AB221,183))
    Last edited by Detritus6; 04-08-2022 at 12:35 AM. Reason: Solved!

  2. #2
    Registered User
    Join Date
    04-07-2022
    Location
    United States
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: Unknown Formula Pause Error

    OOPS! i was missing commas. I'll delete this as soon as i figure out how (If anyone knows how I'd appreciate the info heheh)
    Last edited by Detritus6; 04-07-2022 at 11:26 PM.

  3. #3
    Valued Forum Contributor
    Join Date
    01-07-2022
    Location
    East Asia
    MS-Off Ver
    Office 365
    Posts
    311

    Re: Unknown Formula Pause Error

    Not able to follow along the logic, but might be a lot cleaner and easier to debug using a SWITCH formula:
    https://blog.sheetgo.com/google-shee...google-sheets/
    <<< Please click * to thank valued contributors

  4. #4
    Registered User
    Join Date
    04-07-2022
    Location
    United States
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: Unknown Formula Pause Error

    Woah, that will be extremely helpful for future endeavours, thank you! I'm relatively new to this so I imagine this won't be the last time I learn a new function and realize how much time / brain power I've been wasting haha. It definitely wasn't the first.

+ 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] Formula creating a unique ID - unknown error
    By Median in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2018, 07:52 AM
  2. Help with unknown error
    By wedzmer in forum Excel General
    Replies: 10
    Last Post: 06-28-2015, 11:17 PM
  3. Forensic Accounting Unknown Formula Error Between Worksheets
    By spurredhal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2013, 08:15 PM
  4. Unknown error, possible formula too long.
    By Saidrex in forum Excel General
    Replies: 15
    Last Post: 12-21-2011, 10:41 AM
  5. #VALUE! Error - Unknown cause!
    By downforce in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2007, 10:10 AM
  6. Unknown Error
    By aftamath in forum Excel General
    Replies: 4
    Last Post: 10-06-2005, 03:05 PM
  7. [SOLVED] Help with this error Unknown reason for error with Range().Select
    By Brad Sumner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 12:05 PM

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