Home > Mobile >  How to split the value on specified parts in Google Spreadsheet?
How to split the value on specified parts in Google Spreadsheet?

Time:10-11

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 - enter image description here


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

enter image description here

  • Related