Skip to main content
Topics#Ask An ExpertQuestion de Lakshmi Akula
Lakshmi Akula (Culliganquench) a posé une question dans #Ask An Expert
2 févr. 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 réponses
  1. Ankush Agarwal (Questel)
    2 févr. 2021, 01:51
    Hi Lakshmi,

     

    You may try with below formula:

     

    FLOOR(1975.00/1000)* 1000
Rédiger une réponse...
0/9000