The Cellar

The Cellar (http://cellar.org/index.php)
-   Home Base (http://cellar.org/forumdisplay.php?f=2)
-   -   I need to multiply a lot of fractions by .741 Any advice? (http://cellar.org/showthread.php?t=26728)

footfootfoot 01-22-2012 11:52 AM

I need to multiply a lot of fractions by .741 Any advice?
 
All the online calculators do either fraction by fraction or convert fraction into decimal.

I want to find out what 19/32 * .741 is without having to convert either into something else.

Thoughts?

I suppose since .741 is the constant I could convert that into a fraction and then multiply using a fraction calculator.

Never mind.

Sundae 01-22-2012 12:00 PM

Excel?

HungLikeJesus 01-22-2012 12:21 PM

You could, instead, divide by 1.35.

HungLikeJesus 01-22-2012 12:22 PM

Does your calculator have a constant function? Or can you store the 0.741 in memory?

Clodfobble 01-22-2012 01:13 PM

Even better, use the increasing increment function in Excel--type in 1/32, then 2/32 in the cell below, then 3/32 below that. Then move the cursor to the very bottom right corner of the 3/32 cell until it turns into a plus, and drag it down as far as you need (I'm assuming only up to 32/32.)

Paste the next column with .741, and make the third column A1*B1, A2*B2, etc. Choose whichever answers you need.

footfootfoot 01-22-2012 01:30 PM

I want to have, like, a million of your babies. * .741

Clodfobble 01-22-2012 01:35 PM

Yeah don't strain yourself, 741,000 of my babies is plenty.

footfootfoot 01-22-2012 01:50 PM

I just realized I don't know how to work excel.

glatt 01-22-2012 02:37 PM

I'm always impressed with people who really know excel.

I just use it to list tables of numbers. That might be one of those things that would be worthwhile, actually learning excel.

Clodfobble 01-22-2012 03:29 PM

The increment function is my absolute favorite (I don't even know if that's what it's called, that's just how I think of it.) You can also use it in the equation column above. Just type in A1*B1, then do the same corner-drag and it's smart enough to make the next cell A2*B2, then A3*B3... It can generate a variety of quality graphs from tables of data too.

limey 01-22-2012 06:28 PM

I Luvs me some Excel geekiness! I sometimes get lost for hours in nested functions ...


Sent from my iPod touch using Tapatalk

Trilby 01-23-2012 09:52 AM

I thought this thread was going to be about sopors...

dammit!


All times are GMT -5. The time now is 08:01 AM.

Powered by: vBulletin Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.