I need to multiply a lot of fractions by .741 Any advice?

footfootfoot · 01-22-2012, 11:52 AM

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!

01-22-2012, 11:52 AM	#1
footfootfoot To shreds, you say? Join Date: Aug 2004 Location: in the house and on the street-how many, many feet we meet! Posts: 18,449	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. __________________ The internet is a hateful stew of vomit you can never take completely seriously. - Her Fobs

01-22-2012, 12:21 PM	#3
HungLikeJesus Only looks like a disaster tourist Join Date: Feb 2007 Location: above 7,000 feet Posts: 7,208	You could, instead, divide by 1.35. __________________ Keep Your Bodies Off My Lawn SteveDallas's Random Thread Picker.

01-22-2012, 12:22 PM	#4
HungLikeJesus Only looks like a disaster tourist Join Date: Feb 2007 Location: above 7,000 feet Posts: 7,208	Does your calculator have a constant function? Or can you store the 0.741 in memory? __________________ Keep Your Bodies Off My Lawn SteveDallas's Random Thread Picker.

01-22-2012, 01:13 PM	#5
Clodfobble UNDER CONDITIONAL MITIGATION Join Date: Mar 2004 Location: Austin, TX Posts: 20,012	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 A1B1, A2B2, etc. Choose whichever answers you need. __________________ My book My other book My spirit animal

01-22-2012, 01:30 PM	#6
footfootfoot To shreds, you say? Join Date: Aug 2004 Location: in the house and on the street-how many, many feet we meet! Posts: 18,449	I want to have, like, a million of your babies. * .741 __________________ The internet is a hateful stew of vomit you can never take completely seriously. - Her Fobs

01-22-2012, 12:00 PM	#2
Sundae polaroid of perfection Join Date: Sep 2005 Location: West Yorkshire Posts: 24,185	Excel?

01-22-2012, 01:35 PM	#7
Clodfobble UNDER CONDITIONAL MITIGATION Join Date: Mar 2004 Location: Austin, TX Posts: 20,012	Yeah don't strain yourself, 741,000 of my babies is plenty. __________________ My book My other book My spirit animal

01-22-2012, 01:50 PM	#8
footfootfoot To shreds, you say? Join Date: Aug 2004 Location: in the house and on the street-how many, many feet we meet! Posts: 18,449	I just realized I don't know how to work excel. __________________ The internet is a hateful stew of vomit you can never take completely seriously. - Her Fobs

01-22-2012, 02:37 PM	#9
glatt ™ Join Date: Jul 2003 Location: Arlington, VA Posts: 27,717	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.

01-22-2012, 03:29 PM	#10
Clodfobble UNDER CONDITIONAL MITIGATION Join Date: Mar 2004 Location: Austin, TX Posts: 20,012	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 A1B1, then do the same corner-drag and it's smart enough to make the next cell A2B2, then A3*B3... It can generate a variety of quality graphs from tables of data too. __________________ My book My other book My spirit animal

01-22-2012, 06:28 PM	#11
limey Encroaching on your decrees Join Date: Feb 2004 Location: An island within the south-west coast of Scotland Posts: 7,016	I Luvs me some Excel geekiness! I sometimes get lost for hours in nested functions ... Sent from my iPod touch using Tapatalk __________________ Living it up on the edge ... of civilisation, within the southwest coast of

01-23-2012, 09:52 AM	#12
Trilby Slattern of the Swail Join Date: Jul 2004 Posts: 15,654	I thought this thread was going to be about sopors... dammit! __________________ In Barrie's play and novel, the roles of fairies are brief: they are allies to the Lost Boys, the source of fairy dust and ...They are portrayed as dangerous, whimsical and extremely clever but quite hedonistic. "Shall I give you a kiss?" Peter asked and, jerking an acorn button off his coat, solemnly presented it to her. —James Barrie Wimminfolk they be tricksy. - ZenGum

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)