I have thousands of calculations like this..
=IF(M$2>=$C4,IF($D3=1,IF(ISNA(MATCH(M$2,Sheet6!$AE$5:$AE$29,0)),L6,XLOOKUP(M$2,Sheet6!$AE$5:$AE$29,Sheet6!$AF$5:$AF$29)*M5),IF($D3=2,IF(ISNA(MATCH(M$2,Sheet6!$AE$32:$AE$44,0)),L6,XLOOKUP(M$2,Sheet6!$AE$32:$AE$44,Sheet6!$AF$32:$AF$44)*M5),IF(ISNA(MATCH(M$2,Sheet6!$AE$47:$AE$59,0)),L6,XLOOKUP(M$2,Sheet6!$AE$47:$AE$59,Sheet6!$AF$47:$AF$59)*M5))),0).
This formula is checking logic based on many variables and is returning and calculating variables based on results of the logic. I can't seem to wrap my head around using LET or LAMBDA to help with simplicity and performance. Would using LET or LAMDA help a formula like this?
Thanks
=IF(M$2>=$C4,IF($D3=1,IF(ISNA(MATCH(M$2,Sheet6!$AE$5:$AE$29,0)),L6,XLOOKUP(M$2,Sheet6!$AE$5:$AE$29,Sheet6!$AF$5:$AF$29)*M5),IF($D3=2,IF(ISNA(MATCH(M$2,Sheet6!$AE$32:$AE$44,0)),L6,XLOOKUP(M$2,Sheet6!$AE$32:$AE$44,Sheet6!$AF$32:$AF$44)*M5),IF(ISNA(MATCH(M$2,Sheet6!$AE$47:$AE$59,0)),L6,XLOOKUP(M$2,Sheet6!$AE$47:$AE$59,Sheet6!$AF$47:$AF$59)*M5))),0).
This formula is checking logic based on many variables and is returning and calculating variables based on results of the logic. I can't seem to wrap my head around using LET or LAMBDA to help with simplicity and performance. Would using LET or LAMDA help a formula like this?
Thanks