Using a Cell reference in CEILING.MATH (or MROUND) for the Significance

[Bravo2003]

I'm using this formula in my spreadsheet

=IF(ISBLANK(DI4),CEILING.MATH(DH4,4),"")

But can I get the 'significance' reference (example here is multiples of '4') to reference a cell instead that I can use to change the value to round by in ?
e.g quickly change from Rounding by 4 to rounding by 5 or 10, etc...

Is this possible?

 

[barry houdini]

I don't have CEILING.MATH function but that certainly works for CEILING, just use a cell reference, e.g. A1 like this:

=IF(ISBLANK(DI4),CEILING.MATH(DH4,A1),"")

 

[Jonmo1]

Ceiling.Math is available in my xl2016 (O365) install.
It adds a 3rd optional argument called MODE, that lets you choose for negative numbers to be either toward or away from 0

Anyway, it also will certainly take a cell reference for the 2nd argument.
I would guess the value you have in the cell you tried to use is NOT numeric.

 

[Bravo2003]

I don't have CEILING.MATH function but that certainly works for CEILING, just use a cell reference, e.g. A1 like this:

=IF(ISBLANK(DI4),CEILING.MATH(DH4,A1),"")

OMG, I swear this Excel is out to drive me mad... I tried that earlier and it kept giving me an error box and not letting me do it!
Tried it now and simple..

Thanks