# Unknown Formula Pause Error

1. ## 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))  Register To Reply

2. ## 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)  Register To Reply

3. ## 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:  Register To Reply

4. ## 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.  Register To Reply