Forum Discussion

Bohra999's avatar
Bohra999
Copper Contributor
Aug 30, 2022

Rounding off

I want to round off 100000 to 1000 in excel. What formula should be used
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 30, 2022
Use =LEFT(100000,4)*1 or to refer cell use =LEFT(A1,4)*1

Resources