Hi
Can anyone assist with a way to shorten the below formula and stop the #VALUE! error
=IF(S59>=X59,$Z$22,IF(S59>=(X59*AD22),$Z$20,IF(S59<=(X59*AD20),$Z$19))),IF(S59>=W59,$Z$22,IF(S59>=(W59*AD22),$Z$20,IF(S59<=(W59*AD20),$Z$19))),IF(S59>=V59,$Z$22,IF(S59>=(V59*AD22),$Z$20,IF(S59<=(V59*AD20),$Z$19))),IF(S59>=U59,$Z$22,IF(S59>=(U59*AD22),$Z$20,IF(S59<=(U59*AD20),$Z$19)))
Thankyou
Bookmarks