Can you shorten this formula?= IF($D2>=50000, 50, IF($D2>=49000, 49, IF($D2>=48000, 48, IF($D2>=47000, 47, IF($D2>=46000, 46, IF($D2>=45000, 45, ...

[saikatsarkar]

I'm on Google Sheets
Can you shorten this formula?

= IF($D2>=50000, 50, IF($D2>=49000, 49, IF($D2>=48000, 48, IF($D2>=47000, 47, IF($D2>=46000, 46, IF($D2>=45000, 45, IF($D2>=44000, 44, IF($D2>=43000, 43, IF($D2>=42000, 42, IF($D2>=41000, 41, IF($D2>=40000, 40, IF($D2>=39000, 39, IF($D2>=38000, 38, IF($D2>=37000, 37, IF($D2>=36000, 36, IF($D2>=35000, 35, IF($D2>=34000, 34, IF($D2>=33000, 33, IF($D2>=32000, 32, IF($D2>=31000, 31, IF($D2>=30000, 30, IF($D2>=29000, 29, IF($D2>=28000, 28, IF($D2>=27000, 27, IF($D2>=26000, 26, IF($D2>=25000, 25, IF($D2>=24000, 24, IF($D2>=23000, 23, IF($D2>=22000, 22, IF($D2>=21000, 21, IF($D2>=20000, 20, IF($D2>=19000, 19, IF($D2>=18000, 18, IF($D2>=17000, 17, IF($D2>=16000, 16, IF($D2>=15000, 15, IF($D2>=14000, 14, IF($D2>=13000, 13, IF($D2>=12000, 12, IF($D2>=11000, 11, IF($D2>=10000,10, IF($D2>=9000, 9, IF($D2>=8000, 8, IF($D2>=7000, 7, IF($D2>=6000, 6, IF($D2>=5000, 5, IF($D2>=4000, 4, IF($D2>=3000, 3, IF($D2>=2000, 2, IF($D2>=1000, 1, IF($D2>=0, 0, ""))))))))))))))))))))) )))))))))) )))))))))) ))))))))))

 

[Georgiboy]

Welcome to the forum, maybe something like the below:

=--IF(LEN(A1)=5,LEFT(A1,2),IF(LEN(A1)=4,LEFT(A1,1),0))

 

[RoryA]

Try:

=IF($D2<0,"",INT(MIN($D2,50000)/1000))