|
|
#1
08-18-2023, 01:59 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help with this rounding formula =ROUND(M7/2,2)
|
cathy1 | Excel | 2 | 01-22-2017 08:57 PM |
| How to do round robin email distribution | fretagi | Outlook | 0 | 10-12-2016 11:10 PM |
|
Round num_digits calculated?
|
gebobs | Excel | 1 | 08-03-2016 03:10 PM |
|
Data validation the other way round?
|
Officer_Bierschnitt | Excel | 3 | 11-13-2015 10:12 PM |
|
Round off the number
|
ubns | Word VBA | 4 | 09-06-2012 03:55 PM |
Windows 10 
Office 2019
Threaded Mode