Excel spreadsheet help (formulas)

Excel spreadsheet help (formulas)
by

1 Answer

Answer :

Which version of excel are you using? In 2010 it has a square root function which is =sqrt(CellNameHere). Also as far as the second problem with the multiplication table can you not just use the cell name for example =$B$1*A2 and then drag it down?
by

Related questions

How do I create a simple program that will pull information from a database, insert it into a few formulas, and spit out the answers?

Description : How do I create a simple program that will pull information from a database, insert it into a few formulas, and spit out the answers?

Last Answer : answer:Welcome to Fluther. I have only the vaguest notion of the survey that you're trying to accomplish, but I do understand data. What will serve you very well for this is a ... simple enough exercise, which will only get more complex as your understanding improves and your needs increase.

Excel Help - Macros question?

Description : Excel Help - Macros question?

Last Answer : this is the first post on here that i have not gotten a response for within minutes…I am shocked! Have a stumped your guys?

Anyone know an Excel formula to convert Excel Date/Time to a Time-stamp?

Description : Anyone know an Excel formula to convert Excel Date/Time to a Time-stamp?

Last Answer : Any reason why it has to be a timecode? Could it be a GUID?http://stackoverflow.com/questions/7031347/how-can-i-generate-guids-in-excel

How to automatically post to twitter from an excel sheet?

Description : How to automatically post to twitter from an excel sheet?

Last Answer : Updating from an Excel sheet would be a bit of overkill. What you need to do is find a service that will let you schedule tweets This page has a few options you should look into.

How many built in Formulas in Excel 2013?

Description : How many built in Formulas in Excel 2013?

Last Answer : If by "built in formulas" you mean functions, then there are 341in Excel 2013.

Can you help me think through how to set up an excel spreadsheet to create some graphs?

Description : Can you help me think through how to set up an excel spreadsheet to create some graphs?

Last Answer : Excell graph tutor.

I need help with a 2007 Excel spreadsheet?

Description : I need help with a 2007 Excel spreadsheet?

Last Answer : Ctl-F will open a search window in Excel.

Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Description : Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Last Answer : answer:Okay, my answer is gonna get moderated, but this drives me nuts. Every company I've ever worked at, managers all want to use Excel as if it was a word processor. Excel is not a word processor! ... column to become wide), or causing the text to continue to the into the next cell to the right.

What is the strangest Excel spreadsheet you have seen?

Description : What is the strangest Excel spreadsheet you have seen?

Last Answer : I've used them to map dollhouses, and to create level maps for computer games, for population models, economic models, experience models, for military simulation scenario data, to make maps of game ... they started wanting you to subscribe to Office. I have used Open Office or Libre Office instead.

What is this code that suddenly populated an Excel spreadsheet on my computer?

Description : What is this code that suddenly populated an Excel spreadsheet on my computer?

Last Answer : That looks a lot like a list of Standard Industrial Codes (SIC Codes). From this book How it got onto your workstation, I have no idea. But the data is actually pretty valuable.

What suggestions can you provide for organizing a list of worthwhile quotations in an Excel Spreadsheet?

Description : What suggestions can you provide for organizing a list of worthwhile quotations in an Excel Spreadsheet?

Last Answer : alphabetically by subject matter

I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

Description : I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

Last Answer : You might be able to use the find function =Find(thing_to_find,source) which returns the position of the thing you're looking for within a string in conjunction with Excel's string functions to extract ... you in the right direction. Agree w/ poster below a more specific example would be helpful.

Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Description : Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Last Answer : Yes, but the software would depend on where/how the email addresses are currently stored.

Excel Spreadsheet , PowerPoint , Word Processing What are some examples of software ?

Description : Excel Spreadsheet , PowerPoint , Word Processing What are some examples of software ?

Last Answer : Examples of Excel spreadsheets , PowerPoint , word processing application software.

What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Description : What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Last Answer : Need answer

The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Description : The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Last Answer : (C) Visicalc

What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Description : What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Last Answer : b) A Spreadsheet

What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Description : What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Last Answer : b) A Spreadsheet

Can you help fix this programming problem in Python?

Description : Can you help fix this programming problem in Python?

Last Answer : You can’t treat arrays of digits as a single number. The easiest way to read a numeric string is to use the sys library to read a line from the keyboard. import sys print(“Enter value for mass”) mass = sys.stdin.readline() mass = float(mass)

Programmers: Is this puzzle a "named problem?" and can you help me with it?

Description : Programmers: Is this puzzle a "named problem?" and can you help me with it?

Last Answer : I'd call it enumerating a list of all combinations . There's a field of math called combinatorics which I did not study but I assume probably has a word for this. It doesn't seem like a puzzle ... each iteration, and tweak it to get the output format you want, but that's essentially it, I think.

Geometry Gurus. Can you help me solve for an angle?

Description : Geometry Gurus. Can you help me solve for an angle?

Last Answer : answer:The simplest solution would indeed be to have an IF ELSE statement there and have two separate cases depending on whether (RadialPointY - CenterPointY) is positive (@Angle < 180) or ... values it actually is cannot be determined without some sort of test of (RadialPointY - CenterPointY).

Any programmers willing to help me solve a triangle?

Description : Any programmers willing to help me solve a triangle?

Last Answer : Are you sure whether your language is using degrees vs. radians for the angle?

Any Python programmers willing to help me find a bug?

Description : Any Python programmers willing to help me find a bug?

Last Answer : Anything for the sake of science. I will look at the code and see if I can find the bug. As I understand it, you want to find the number of distinct locus values. By just looking at the csv ... just how the parsing is supposed to work. Also, what is the calling sequence to get the program started?

MySQL help!

Description : MySQL help!

Last Answer : answer:You spelled “propeller” wrong, for one thing. Table SERVICE_REQUEST has a primary key, SERVICE_ID, which is a DECIMAL field. In your attempt to load the table with the error record, the secondary key value you attempted to insert for SERVICE_ID, ‘7’ is a CHAR value. That’s a show-stopper.

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?

Does anyone here have experience working with PL/SQL? I need some help getting started...

Description : Does anyone here have experience working with PL/SQL? I need some help getting started...

Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.

Hey mathematicians, would you like to help me find patterns between rolling ball clocks?

Description : Hey mathematicians, would you like to help me find patterns between rolling ball clocks?

Last Answer : answer:I read the article & watched the video, but I don't get it. It takes 27 balls to display 12:59 (12 balls on the hours rack, 11 on the 5-min, 4 on the 1-min). But ... there are no simple rules among the numbers you've compiled. In other words, your algorithm might be its shortest description!

Can you help me find an App that can help one make App's? (any platform, including pen and paper, details inside)

Description : Can you help me find an App that can help one make App's? (any platform, including pen and paper, details inside)

Last Answer : answer:I'm not sure if it's quite what you're looking for, but my buddy makes AppCooker. You can use it with AppTaster to create mockups and make them play. I can't speak to their efficacy personally because ... charge $75-125/hour. If that's the route you end up wanting to take, feel free to PM me.

Can somebody help me finding e-books to download for programming for MIT, Oxford, Harvard etc?

Description : Can somebody help me finding e-books to download for programming for MIT, Oxford, Harvard etc?

Last Answer : answer:“MIT OpenCourseWare makes the course materials that are used in the teaching of almost all MIT’s undergraduate and graduate subjects available on the Web, free of charge” http://web.mit.edu/ocw/

How to use cron in ruby on rails (2.3.5). Please help?

Description : How to use cron in ruby on rails (2.3.5). Please help?

Last Answer : answer:At the UNIX prompt, type man crontab and help documentation will appear. - Crontab is the interface you use to schedule jobs in cron. It launches a basic text editor - usually vi but anything you want - and you enter in one ... . 30 21 * * 3 /path/to/maintenance.sh # #---------------------

Help with a basic Java program?

Description : Help with a basic Java program?

Last Answer : answer:just a guide, don’t know java correct the syntax and stuff and this should be your loop. INPUT=B for(A=1; A=0; a=a-1){ print/echo/say ”*”; } print linebreak// } for(A=B; A=>0; A=A-1){ for(a=A; a=>0; a=a-1){ print/echo/say ”*”; } print linebreak// }

Help assignment of Linear Programming?

Description : Help assignment of Linear Programming?

Last Answer : answer:It's just a means of solving problems when there are apparently too many variables to otherwise make sense of the situation with a simple algebraic solution. The problem needn't be complex, it only ... and how to set up the problem, see the site: http://www.purplemath.com/modules/linprog3.htm

Did Network TV Programming Strategy help cable clean their clocks?

Description : Did Network TV Programming Strategy help cable clean their clocks?

Last Answer : answer:They do something really, really stupid - they split the crowd. This is something I'm trying to help a few bar owners I know figure out. When there's a local metal show at Bar 1, ... worried about not letting each other make a decent profit, they're cutting their own profit in the process!

Can you help me find some useful Wordpress plugins?

Description : Can you help me find some useful Wordpress plugins?

Last Answer : just to be sure you’ve checked wordpress plugins page right? you want each post to turn like a page? i think you would need to make that specially with either flash or ajax or something.

Help with an error I am getting in VBA?

Description : Help with an error I am getting in VBA?

Last Answer : You might not have used selection with proper object. You can check it out in object browser (View->Object Browser) if the object you've used has that property/method or not. For example, if you are trying to ... block, make sure you end it with End With . Example: With Cells(1,1) .Value=1 End With

Javascript help, please?

Description : Javascript help, please?

Last Answer : any ideas, anyone?

[PHP] Forgot Password Help?

Description : [PHP] Forgot Password Help?

Last Answer : You could try using the built in PHP crypt() function, you pass the string and a salt you want to encrypt, then to decrypt it use the decrypt() function and the same salt. That should give you the same password back. Though really you should try to push for a randomly generated password on reset.

Can anyone help me with some CSS?

Description : Can anyone help me with some CSS?

Last Answer : How is it jumbled? Often for IE i use a second stylesheet and apply it using : < ![endif]—> The first one is your first stylesheet, the second is a stylesheet that only fixes the things that are bad in IE.

Mail.app crashing at launch. Help, please?

Description : Mail.app crashing at launch. Help, please?

Last Answer : I would run disc utility and fix permissions then reboot

Help With Tumblr (Disqus Comments)

Description : Help With Tumblr (Disqus Comments)

Last Answer : I just ran into this same problem. I don’t suppose you know the answer yet…

I have filled in all the information. Finally the invoice is something. Then comes the merchant number and bKash personal number. And with the reference number is coming. How can I make the payment. Help! ?

Description : I have filled in all the information. Finally the invoice is something. Then comes the merchant number and bKash personal number. And with the reference number is coming. How can I make the payment. Help! ?

Last Answer : I think you want to buy something hosting or domain type , if so you take their personal number from your provider. Then send money by developing that number. And give the number from which you sent the money to their live support. They will pay the payment.

Describe re-entrant procedure with the help of schematic diagram.

Description : Describe re-entrant procedure with the help of schematic diagram.

Last Answer : Re-entrant Procedures: A procedure is said to be re-entrant, if it can be interrupted, used and re-entered without losing or writing over anything. To be a re-entrant, Procedure ... program execution flow reenters in the procedure1. These types of procedures are called reentrant procedures.

Salesforce SDK uninstallation from XCode?

Description : Salesforce SDK uninstallation from XCode?

Last Answer : Too many variables – only you know your code, how it was written, and how extensible (or not) it was in the first place. I assume you have been to the Saleforce API and SDK pages.

Is there a program where you can identify music in a specific website?

Description : Is there a program where you can identify music in a specific website?

Last Answer : Need Answer

What is a good programming language to make a multiple choice quiz?

Description : What is a good programming language to make a multiple choice quiz?

Last Answer : Google classroom should work.

Is there a website that shows all the English words, idioms, etc ever invented, including archaic, unofficial, and newest words that have just been invented?

Description : Is there a website that shows all the English words, idioms, etc ever invented, including archaic, unofficial, and newest words that have just been invented?

Last Answer : The problem with such a lexicon would be that there have been a lot of slang, dialect, idioms, and unofficial words that 99% of people have never heard of. Besides that, the English language is ... pretty good vocabulary. Hopefully, someone will recommend some. I am unable to do this at the moment.

How can I add HTML markup to this ajax result?

Description : How can I add HTML markup to this ajax result?

Last Answer : Need Answer

Function or application allowing me to connect or disconnect wifi?

Description : Function or application allowing me to connect or disconnect wifi?

Last Answer : Some routers - Belkins and older Ciscos, had an app that would allow you to remotely-control your router from your phone. You didn't say what kind of router you have, so it's hard to guess. You can ... . Bottom line - you can do this easily if you have a wifi-based power switch and an app. example

How can I become advanced in javascript in 2 months?

Description : How can I become advanced in javascript in 2 months?

Last Answer : Study hard…work hard!!!

What's the best book for understanding Unity 2D?

Description : What's the best book for understanding Unity 2D?

Last Answer : Are you a beginner programmer in general, or just new to Unity? That would make a big difference in how I would respond.