Results 1 to 4 of 4

Limiting decimal points doing division.

Threaded View

  1. #1
    Registered User
    Join Date
    12-26-2007
    Posts
    29

    Limiting decimal points doing division.

    If I do per say =10/3 and the result would be 3.333333. How do I limit the output to only 2 decimal points. It's not an issue of not seeing the repeating 3 but I need it to display two places after the decimal.

    I can use the =FIXED function but it will convert it to text.

    Any other options to keep it as a number?

    Thanks,
    Pavel


    DaddyLonglegs, Thank you for the help. I had done a cash on cash return ratio and it worked fantasticly. It got complicated but I got the result I was looking for.
    Last edited by plitv001; 12-27-2007 at 12:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1