LinkBack URL
About LinkBacks
Hi,
I'm having trouble finding how to round -345 to -1000?? (Both Minus)
I know how to do it with positive numbers but negativs are eluding me
Much thanks
Hi,
I'm having trouble finding how to round -345 to -1000?? (Both Minus)
I know how to do it with positive numbers but negativs are eluding me
Much thanks
Not sure what you would want other values to be. Does this work for you?
Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
hi zhb12810. Assuming -345 is in A1, you can try:
=ROUNDUP(A1,-3)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Guys, ChemistB thats just what i needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks