Google Sheets – Round Float to Nearest Larger Integer

Wouldn't a more simple way of doing this be done using functions in the actual sheet?

Up: =MROUND(A1+0.25;0.5)
Down: =MROUND(A1-0.25;0.5)

I would assume that having another column added to the spreadsheet that takes the Google Forms input and performs the rounding function on it, then use Apps Script to email the data would be easier than than trying to do it all in a script.

Unfortunately the partial solution found does not appear to be extendable beyond two numeric ranges, so as an alternative there is an extendable but not generalised solution that converts integers greater than 999 to text in order to display as required up to trillions (short scale) but not quadrillion or above (though more terms may be added):

=if(A1<1000,A1,if(A1<1000000,text(A1/1000,"#.0")&"K",if(A1<1000000000,text(A1/1000000,"#.0")&"M",if(A1<1000000000000,text(A1/1000000000,"#.0")&"B",text(A1/1000000000000,"#.0")&"T"))))