incorcopate two functions SUM and CEILING

Evening All,

Looking through the forum I found this function that rounds numbers to the nearest quarter of a number

HTML Code: 

How would I incorporate this into

HTML Code: 

Where the cell that needs to incorporate the two functions is I15

Thank you

Ostensibly:

=CEILING(G15*H4/100, 0.25)

(Your use of SUM was superfluous.)

But CEILING does not "round" to the nearest 0.25 multiple; it rounds up. Use MROUND to round up or down to the nearest.

Fantastic,

so i would use

HTML Code: 

Correct?

Well, that was my intent. Try it, and see if it works for you. I have no idea about what values you have in G15 and H4, especially whether or not they are rounded as you intend them to be (or not).

If you do need some additional help, please be sure to include related values and formulas with any follow-up questions. I recommend formatting cells so that they display 15 significant digits, especially if there are any unexpected calculation results.