I have 1 column with total numbers and some additional columns with targets. I need to find the formula to find if each target was reached for each value. Please see the example -
update:
=INDEX(LAMBDA(x, {
IF(x<0, "-", IF((x>=0)*(x<48), x, 47)),
IF((x-47)<0, "-", IF(((x-47)>0)*((x-47)<13), x-47, 12)),
IF((x-59)<0, "-", IF(((x-59)>0)*((x-59)<20), x-59, 20)),
IF((x-79)<0, "-", IF(((x-79)>0), x-79, ))})(G2:G7))