LumberJocks

Format your excel formulas to inches and fractions

  • Advertise with us
Blog entry by ScottM1 posted 12-07-2014 11:52 AM 1972 reads 2 times favorited 8 comments Add to Favorites Watch

Have you ever had the result of a formula in excel to return something like 17.3333 then tried to format that cell to fractions up to two digits? Only to get a result of 17 1/3 when you really need it to be in 1/32, 1/16 or 1/64 increments.

Well I have a solution for you.

In this video I will demonstrate how you can use the MROUND function to accomplish this.

So check it out and let me know what you think.

Here is the link. http://youtu.be/Jfy_lglzNhA

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips



8 comments so far

View stefang's profile

stefang

15512 posts in 2796 days


#1 posted 12-07-2014 01:36 PM

Many will thank you for this link. I work in metrics so I don’t really need it, but those working with inches certainly should get a lot of use out of it.

-- Mike, an American living in Norway.

View ScottM1's profile

ScottM1

126 posts in 1045 days


#2 posted 12-07-2014 01:42 PM



Many will thank you for this link. I work in metrics so I don t really need it, but those working with inches certainly should get a lot of use out of it.

- stefang


Thanks Mike for the complement
So how do you like living in Norway?

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips

View sras's profile

sras

4391 posts in 2591 days


#3 posted 12-07-2014 08:40 PM

Nice tip. Thanks!

-- Steve - Impatience is Expensive

View ScottM1's profile

ScottM1

126 posts in 1045 days


#4 posted 12-07-2014 09:20 PM



Nice tip. Thanks!

- sras


Thank you sir! It is definitely a morale booster to get a complement on a subject like this from someone with a background like yours.

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips

View oldnovice's profile

oldnovice

5723 posts in 2830 days


#5 posted 12-08-2014 06:26 AM

At one time I did a great deal of Excel programing with VB for Excel automation but ever since Microsoft started subscription service for their office package I switched over to Open Office (free from Oracle) and it has the same, plus some more, applications than MS Office.

I am retired and I don’t want to contribute to Mr. Gates retirement any more!

Open Office can open and use the MS Office files and it is FREE!

-- "I never met a board I didn't like!"

View stefang's profile

stefang

15512 posts in 2796 days


#6 posted 12-08-2014 09:32 AM

Hi Scott. I like it a lot, having lived here about 37 years altogether, but getting hold of stuff for woodworking can be difficult and frustrating at times. That situation has improved a lot the last few years with the advent of online shopping though, so it’s not as bad now as it was.

-- Mike, an American living in Norway.

View Douglas's profile

Douglas

414 posts in 2022 days


#7 posted 12-10-2014 11:53 PM

for those times when I have to do a lot of fraction adding/subtracting/dividing (more than one or two operations), I have been using this iPhone app, Builder's Helper that does a pretty good job of it.

-- Douglas in Chicago - http://dcwwoodworks.com

View ic3ss's profile

ic3ss

387 posts in 2239 days


#8 posted 12-29-2014 04:49 PM

Nice woraround. I use my project calculator ipad app. It also shows me board area usage garphic. Way easier than writing excel formulas.

Wayne

-- "I am endeavoring, ma'am, to construct a mnemonic memory circuit using stone knives and bear skins."

Have your say...

You must be signed in to post the comments.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com