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

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

Sorry, but I can't get this one to work for me.

When I posted my original question I mis-typed my function. This is a
corrected version.

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

Now assuming that D2 is $6897.75, my function results in $3448.88 which
is correct, but only works if D2 is a positve number.

=ROUND(D2*5,0)/100 yields $344.89




I tried =ROUND(D2*5,0)/10 but this tields $3448.90