cancel
Showing results for 
Search instead for 
Did you mean: 

Ceiling Calculation

CLewis
8 - Cloud Apps
8 - Cloud Apps

Wondering if any knows a way to use the ceiling calculation to round to the nearest 1000? I am trying to recreate this Excel calculation. 

=CEILING(P4,1000)-100        P4= $379,083.04  answer should be $379,900

1 ACCEPTED SOLUTION

harikm007
13 - Data Warehouse
13 - Data Warehouse

@CLewis 

Please try if this formula works for you:

CEILING([Total value]/1000)*1000

-Hari

View solution in original post

2 REPLIES 2

harikm007
13 - Data Warehouse
13 - Data Warehouse

@CLewis 

Please try if this formula works for you:

CEILING([Total value]/1000)*1000

-Hari

This worked perfect thank you.