Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Math and Excel help please
Old 02-15-2015, 03:04 PM   #1
Full time employment: Posting here.
 
Join Date: Mar 2008
Posts: 637
Math and Excel help please

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.

Thanks in advance.
Attached Images
File Type: jpg math.jpg (11.9 KB, 209 views)
__________________

__________________
bizlady is offline   Reply With Quote
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!

Old 02-15-2015, 03:10 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
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)
Midpack is offline   Reply With Quote
Old 02-15-2015, 03:12 PM   #3
Recycles dryer sheets
latexman's Avatar
 
Join Date: Mar 2014
Location: Apex, NC
Posts: 147
Its the operator for Square root function.


=SQRT(2x100x15/2) or =SQRT(1500)
__________________
latexman is offline   Reply With Quote
Old 02-15-2015, 03:12 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
HFWR's Avatar
 
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,964
Quote:
Originally Posted by Midpack View Post
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...
HFWR is offline   Reply With Quote
Old 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!
__________________
bizlady is offline   Reply With Quote
Old 02-15-2015, 04:03 PM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
easysurfer's Avatar
 
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
easysurfer is offline   Reply With Quote
Old 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??
__________________
jwkde is offline   Reply With Quote
Old 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 View Post
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.
__________________
meierlde is online now   Reply With Quote
Old 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.
__________________
H2ODude is offline   Reply With Quote
Old 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
poorcarver is offline   Reply With Quote
Old 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 View Post
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.
__________________
meierlde is online now   Reply With Quote
Old 02-16-2015, 11:14 AM   #12
Thinks s/he gets paid by the post
sengsational's Avatar
 
Join Date: Oct 2010
Posts: 3,828
Quote:
Originally Posted by poorcarver View Post
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.

__________________

__________________
sengsational is offline   Reply With Quote
Reply


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

Advanced Search
Display Modes

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 Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with determining number combinations - for all you engineers and math geeks! Lisa99 Life after FIRE 18 10-31-2014 09:06 AM
Looking for some Excel help Bimmerbill Other topics 3 07-23-2010 07:08 PM
Help needed on Excel spreadsheet design peteyperson FIRE and Money 5 05-08-2008 08:56 AM
A little Math help please nnkrealtor Other topics 1 02-11-2008 10:04 AM

 

 
All times are GMT -6. The time now is 09:16 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.