Force function to show positive or negative number?

[smoore]

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

 

[JE McGimpsey]

one way:

=ROUND(D2*5,0)/100

 

[smoore]

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

 

[JE McGimpsey]

When I posted my original question I mis-typed my function.

Looks like your corrected function can be replaced with

=ROUND(D2/2,2)

I'm not sure why you were using IF(ISERROR(...)) - normally you would
want to eliminate the error in D2, but you could use

=IF(ISERROR(D2),"",ROUND(D2/2,2))

 

[smoore]

Looks, like we've gotten there now. What I finaly found to work stems
from your last suggestion.

=IF(ISERROR(D2/2,2)),"",ROUND(D2/2,2))

This leaves me a clean worksheet if there are no figures in D2 where
before if D2 was still empty I had #value errors. This works perfectly.
Thank you very much for your help.

Scotty