CLewisCloud Apps01-26-2022SolvedCeiling Calculation 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...Show Moreharikm00701-26-2022CLewis Please try if this formula works for you: CEILING([Total value]/1000)*1000 -Hari
harikm00701-26-2022CLewis Please try if this formula works for you: CEILING([Total value]/1000)*1000 -Hari
harikm00701-26-2022CLewis Please try if this formula works for you: CEILING([Total value]/1000)*1000 -Hari
harikm007Data Warehouse01-26-2022CLewis Please try if this formula works for you: CEILING([Total value]/1000)*1000 -Hari
Recent DiscussionsColumn Chart Break By Max No SeriesPivot Table widget - column headers and column data out of alignmentBlox conditional formatting up and down indicatorsRemove Widget Title BoxSolvedChange Legend Category Names
