LinkBack URL
About LinkBacks
I work in excel 2010 and I have a formula for a ratio and would like to format the ratio so that the result is 17.8:1 in all cells. Some cells are giving me 4.53333333333333:1. Is there a way to format the result to just show one decimal place?
I work in excel 2010 and I have a formula for a ratio and would like to format the ratio so that the result is 17.8:1 in all cells. Some cells are giving me 4.53333333333333:1. Is there a way to format the result to just show one decimal place?
Probably.
What's your formula?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
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.
Or maybe play around with this?
=SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=(i2/h2)&":"&(h2/h2)
Try =FIXED((i2/h2),1)&":"&(h2/h2)
I used =ROUND((I2/H2),1)&":"&(H2/H2) that has corrected the formatting now I just need to get rid of the #DIV/0! and add conditional formatting and I will be done. Thanks for your input.
This should get rid of the #DIV/0! issue:
=IFERROR(ROUND((I2/H2),1)&":"&(H2/H2),"")
duplicate ...
Last edited by shg; 09-08-2014 at 08:40 PM.
Entia non sunt multiplicanda sine necessitate
Or
=IF(N(H2), ROUND(I2/H2, 1) & ":1", "")
Re: Formatting ratio formula results
Thank you all for your help, it looks great. I put a 0 between the "" so to not leave the field blank. This is my first post on this forum but I am sure it will not be my last. I am searching for how to mark this solved and to give a star to a reply that helped as the moderator suggested but I haven't found them yet so please be patient with this newbie!!
Was I successful marking the post solved? Do I start a new one if I want to add to the formula or edit this formula?
You can continue here if it's on the same topic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks