Ceiling Calculation

[CLewis]

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

[harikm007 · Accepted solution]

@CLewis 

Please try if this formula works for you:

CEILING([Total value]/1000)*1000

-Hari

[CLewis]

This worked perfect thank you.