I need my ratio to show 1:# (no decimals).
Here's my formula:
=IF(M29=0,0,(1&":"(I29/M29)))
M29= 2
I29= 7
Ratio showing as 1:3.5 and I need it to show 1:4.
Any help is appreciated!
I need my ratio to show 1:# (no decimals).
Here's my formula:
=IF(M29=0,0,(1&":"(I29/M29)))
M29= 2
I29= 7
Ratio showing as 1:3.5 and I need it to show 1:4.
Any help is appreciated!
I think that's what you want
Formula:Please Login or Register to view this content.
You could do this:
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
=if(m29=0;0,1&":"&ceiling((i29/m29),1))
Both of these get the job done- thanks to you both!
Deleted by author
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Glad they work for you. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks