02-15-2015, 03:04 PM   #1
Full time employment: Posting here.

Join Date: Mar 2008
Posts: 637

I am trying to create a formula, like the attached, in an excel worksheet.
Can anyone help me??

I know the stars are multipliers, and the single straight line is a division, but have no idea what the other symbol represents, or how to create this in excel.

Attached Images
 math.jpg (11.9 KB, 209 views)
__________________

__________________

 Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free! Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE! You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more! Join Early-Retirment.org For Free - Click Here
 02-15-2015, 03:10 PM #2 Give me a museum and I'll fill it. (Picasso)Give me a forum ...   Join Date: Jan 2008 Location: Chicagoland Posts: 11,968 The other symbol is square root of. I assume you plan to replace some terms with variables if you're using Excel. In Excel: =SQRT(2*100*15/2) The answer is 38.73 if that's what you were after. __________________ __________________ No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne Retired Jun 2011 at age 57 Target AA: 60% equity funds / 35% bond funds / 5% cash Target WR: Approx 2.5% Approx 20% SI (secure income, SS only)
 02-15-2015, 03:12 PM #3 Recycles dryer sheets   Join Date: Mar 2014 Location: Apex, NC Posts: 147 Its the operator for Square root function. =SQRT(2x100x15/2) or =SQRT(1500) __________________
02-15-2015, 03:12 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...

Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,964
Quote:
 Originally Posted by Midpack I assume you plan to replace some terms with variables if you're using Excel. =SQRT(2*100*15/2)

Or (2*100*15/2)^0.5
__________________
Have Funds, Will Retire

...not doing anything of true substance...

 02-15-2015, 03:24 PM #5 Full time employment: Posting here.   Join Date: Mar 2008 Posts: 637 AWESOME-- thank you. Trying to build an inventory forecast sheet. Found this formula which makes sense for my hobby business, with the example, but could not create it in excel. Now I can insert my numbers and should be good. Again thanks! __________________
 02-15-2015, 04:03 PM #6 Give me a museum and I'll fill it. (Picasso)Give me a forum ...   Join Date: Jun 2008 Posts: 7,885 The Square Root... brings back nightmarish flashbacks of grade school __________________ Have you ever seen a headstone with these words "If only I had spent more time at work" ... from "Busy Man" sung by Billy Ray Cyrus
 02-16-2015, 06:40 AM #7 Recycles dryer sheets   Join Date: Jan 2010 Posts: 174 ok but who remembers how to do square roots on a slide rule?? __________________
02-16-2015, 08:21 AM   #8
Thinks s/he gets paid by the post

Join Date: Mar 2010
Location: Kerrville,Tx
Posts: 2,710
Quote:
 Originally Posted by jwkde ok but who remembers how to do square roots on a slide rule??
Look for a scale that is either goes from 1 to 100 or goes from 1 to 3.16 and 3.16 to 10 (The first is a square scale teh second a square root scale) The square scale is called an A scale and the square root scale is typically r1 and r2. If you have an A then slide the cursor to the number on a and read the square root on the C. If you have R 1 and R2. Set the cursor on the C and depending see if the power of 10 involved is even or odd use r1 if even (0,2...) or R2 if odd (1,3...) read off the square root.
__________________

 02-16-2015, 08:45 AM #9 Thinks s/he gets paid by the post   Join Date: Feb 2012 Posts: 1,103 Ahh, slide rules. One of the few mementos I have of my career is a glass front shadow box I built of my grandfather's (electrical), my Dad's (chemical) and mine (civil). Yeah, I saved up the \$150 in 72 (bear in mind a four function) to replace it but still had it. Suppose I could have asked DS and DD for their first calculators to go in it...both chemicals. Engineering has tended to run in the family, be interesting to see if any of the 5 grandchildren go that way. __________________
 02-16-2015, 09:33 AM #10 Recycles dryer sheets   Join Date: Nov 2010 Location: Little Trailer Down By The River Posts: 172 I have mine sitting on my desk just because. I took the professional engineers exam with that thing. __________________ "Here's to them who would read, Here's to them that would write. There's none ever feared that the Truth would be heard, But those whom the Truth would indict." Robert Burns
02-16-2015, 09:47 AM   #11
Thinks s/he gets paid by the post

Join Date: Mar 2010
Location: Kerrville,Tx
Posts: 2,710
Quote:
 Originally Posted by poorcarver I have mine sitting on my desk just because. I took the professional engineers exam with that thing.
Mine sits in a drawer, I got thru 8 years of college with it. It is a log log slide rule.
__________________

02-16-2015, 11:14 AM   #12
Thinks s/he gets paid by the post

Join Date: Oct 2010
Posts: 3,828
Quote:
 Originally Posted by poorcarver I have mine sitting on my desk just because. I took the professional engineers exam with that thing.
And also, you never know when you'll need to do some computing after that big EMP knocks out the electronics, hehe.

I didn't throw mine out, but I couldn't find mine now if I had to. Got mine in HS. Although "everyone" had TI-58's, they didn't want to exclude people that couldn't afford one.

__________________

__________________

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

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Lisa99 Life after FIRE 18 10-31-2014 09:06 AM Bimmerbill Other topics 3 07-23-2010 07:08 PM peteyperson FIRE and Money 5 05-08-2008 08:56 AM nnkrealtor Other topics 1 02-11-2008 10:04 AM