one way:

=ROUND(D2*5,0)/100

In article .com,
"smoore" wrote:

I'm using the following function in a spreadsheet, and it works fine as
long as the number is a positive number. However, if the number is a
negative, I have to add a negative sign to the multiple criteria of the
MROUND function. Is there a work around that would make this function
show both positive or negative numbers?

=IF(ISERROR(MROUND(D2*0.5,0.01)," ",MROUND(D2*.05,0.01))

Changed =IF(ISERROR(MROUND(D2*0.5,-0.01)," ",MROUND(D2*.05,-0.01))


Thanks