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))
Bookmarks