Thread: [Solved] Round Down Sum Formula
View Single Post
 
Old 08-18-2023, 01:59 AM
tomohawk tomohawk is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Sep 2020
Location: Dublin
Posts: 62
tomohawk is on a distinguished road
Default Round Down Sum Formula

Hi, I want to create a sum formula, but to round DOWN to nearest 5 e.g.

Cell B4 = 125.90
Cell C4 = 213.20

The formula =sum(C4:B4) would give a result of 339.1

I want to add a round function, so that the result will be rounded down to the nearest 5 (or multiple of) i.e. 335.0

Tommy
Reply With Quote