+ Reply to Thread
Results 1 to 3 of 3

How to display a ratio but have it calculate as a decimal?

  1. #1
    Registered User
    Join Date
    12-22-2011
    Location
    americuh
    MS-Off Ver
    Excel 2003
    Posts
    36

    How to display a ratio but have it calculate as a decimal?

    Hi all, i'm trying to display a ratio in my spreadsheet to show the "odds" but i want it to calculate as its decimal, so if i had 1:20 written in it then i want 0.05 to be the value of the cell when i use it in a formula. Is there any way to do this? So far ive only gotten it to show up as a ratio by typing '1:20 with the apostrophe in front of it.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How to display a ratio but have it calculate as a decimal?

    Assume the ration 1:20 is on B2. Try this formula,

    =LEFT(B2,FIND(":",B2)-1)/RIGHT(B2,LEN(B2)-FIND(":",B2))
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: How to display a ratio but have it calculate as a decimal?

    If you are willing to use the '/' character as your ratio delimiter rather than the ':', you can use a number format code like ##/## to display a decimal as a fraction.

+ Reply to Thread

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