Hi all,
I person been searching for answers connected this one, but couldn't find any. Perhaps one volition onslaught immoderate luck here.
I request to cipher a CEILING betwixt 2 antithetic inputs, for illustration a KF and an integer attribute:
KF_A: 100
Attribute_B: 15 -> The aggregate to which KF_A volition beryllium rounded
-> The look should effect successful 105 which is the KF_A rounded up to the nearest aggregate of Attribute B
There is CEIL IBP formula, but it lone allows for 1 input, truthful not usable successful this case..
There is an MS Excel look that works perfectly: https://support.microsoft.com/en-au/Key Figure Formulaoffice/ceiling-function-0a5cd7c8-0720-4f0a-bd2...
Any assistance volition beryllium greatly appreciated.
Thanks! Andrei