Skip to main content
Topics#Ask An ExpertFrage von Lakshmi Akula
Lakshmi Akula (Culliganquench) fragte in #Ask An Expert
2. Feb. 2021, 01:48

Rounding off downwards

Hi All,

 

How can I round off my number to downwards?

 

For Example :

 

1,233.00 = 1K

 

1,630.00 = 1K

 

1,975.00 = 2K

 

Want to display as follows:

 

1,233.00 = 1K

 

1,630.00 = 1K

 

1,975.00 = 1K

 

I have used the formula FLOOR(1975.00) it is rounding off to 2K.

 

Thanks 

 

Lakshmi
2 Antworten
  1. Ankush Agarwal (Questel)
    2. Feb. 2021, 01:51
    Hi Lakshmi,

     

    You may try with below formula:

     

    FLOOR(1975.00/1000)* 1000
Antwort schreiben...
0/9000