#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Code:
=round(sum(b4:c4)/5,1)*5 Code:
=ROUNDDOWN(SUM(B4:C4)/5,1)*5 |
#3
|
||||
|
||||
Try
Code:
=FLOOR(sum(C4:B4),5)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Thanks guys.
FLOOR works for me Tommy |
#5
|
||||
|
||||
You're welcome. Adding some rep would be nice too...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |