Rounding to whole numbers, divisible by 3 or 4 !

All of the numbers in your examples are divisible by 4. Why do you need to round them up if they are already divisible by 4? And rounding to the nearest multiple of 3 would require rounding down in the first two cases, to 87 and 111.

So I have a little formula table I use every day - it does some calculations and then spits out a number - I then manually round the number up or down to the nearest whole number divisible by 3 or by 4.

For example, 88 I round to 90.

112, round up to 120.

44, to 45.

Your examples don't follow your description; 88, 112, and 44 are all divisible by 4.

Short but useless answer -- yes, Excel can do this for you. As others have suggested, I'm not sure your description provides enough detail about the desired results, so it is difficult to come up with an algorithm.

Combining the information in the OP and post #4, maybe you are looking to round (round up or round to nearest?) to a multiple of 5 that is also a multiple of 3 or 4. I think that would mean that the solution set would be the combined set of the multiples of 15 (0,15,30,45,60,75,...) and 20 (0,20,40,60,80,100,...) [combined set = (0,15,20,30,40,45,60,75,80,90,100,105,120,135,140,...)]. Is that correct?

Whether that is exactly correct or not, a brute force approach might be to make a list of all the allowed results, then use a lookup function (probably MATCH() https://support.office.com/en-us/art...9-533f4a37673a ) with one of the the "approximate match" options (3rd argument of MATCH() is +1 or -1) to look up the result. For something like "round up to the nearest multiple of 15 or 20", I could have a list of all possible values (in descending order), then use =INDEX(list in descending order,MATCH(value,list in descending order,-1)) and that should work for that scenario.

I think MrS has broken the code:

	A	B	C
1	Nearest up:
2	88	90	B2: =MIN(CEILING(A2, {15,20}))
3	112	120
4	45	45
5	77	80
6
7	Nearest up or down:
8	88	90	B8: =IF(ABS(MROUND(A8, 15) - A8) < ABS(MROUND(A8, 20) - A8), MROUND(A8, 15), MROUND(A8, 20))
9	112	105
10	45	45
11	77	75

Good mindreading