Results 1 to 13 of 13

Formatting ratio formula results

Threaded View

  1. #3
    Forum Contributor
    Join Date
    05-04-2014
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2010, 2013
    Posts
    120

    Re: Formatting ratio formula results

    Maybe something like this?

    =TEXT(A1/B1,".#")&":1"

    or this:

    =ROUND(A1/B1,1)&":1"

    or go to the cell properties and format as custom (by typing .# into the bar on the custom tab)

    Where A1 and B1 are the two numbers being divided to achieve the ratio.
    Last edited by clabulis; 09-08-2014 at 05:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2010 Conditional Formatting: Cell Color Change, Based on Ratio (1:1)
    By James_D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2013, 09:02 PM
  2. [SOLVED] Conditionally Formatting Formula Results
    By GaidenFocus in forum Excel General
    Replies: 6
    Last Post: 06-15-2012, 12:21 PM
  3. Conditional Formatting based on a ratio
    By kmlloyd in forum Excel General
    Replies: 2
    Last Post: 02-24-2010, 03:16 PM
  4. [SOLVED] Divide x/y should give Ratio x:y,How to express ratio in excel
    By arvind3738 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2006, 03:29 AM
  5. ratio formatting
    By uteowl in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 09:06 PM

Tags for this Thread

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