Algebra/Pythagoras/Equation in Excel - Please Help - For Assignment

**toyecharlie1** · 03-14-2013, 06:00 AM

Hello,

I am needing to substitue x for a range of numbers (you can begin to see the list at the bottom of this attachment)
What is the quickest way I can do this in excel? I'm really stuck!

Forget the X minimum and maximum, that is just a range of numbers.

Thanks, Charlie

**Pepe Le Mokko** · 03-14-2013, 06:26 AM

Hi
While images are nice, they are utterly useless. Please post a sample sheet

**toyecharlie1** · 03-14-2013, 06:55 AM

Hello, I am really sorry for not initially attaching it! Here it is!Maths Task 4.xlsx

**MrShorty** · 03-14-2013, 10:41 AM

I still don't understand what it is you need. Your attached spreadsheet does not add any new information. Are the values in column A (0 to 6) your desired x values? And then you need to create formula for column B that will calculate the given formula [sum(sqrt(16+x^2),sqrt(45-12x+x^2))]? If this is all you need to do, it should be as easy as putting that formula into column B with references to column A. With the correct combination of relative and absolute references (in case you decide to put the constants into cells for easy editing), it should be a simple copy and paste or drag the fill handle to fill in column B (http://office.microsoft.com/en-us/ex...es_in_formulas).

**toyecharlie1** · 03-14-2013, 05:38 PM

That's exactly what I need to do! Is there anway you could help me, because excel can't work out the formula!

**MrShorty** · 03-14-2013, 06:14 PM

I'm sure I could help you, but I'm not sure what you are stuck on. Are you having trouble with the sqrt() function? or is it writing the polynomials? Something about using references in formulas that you didn't understand from the help file?

**toyecharlie1** · 03-15-2013, 10:44 PM

Thanks for your help but it's all sorted!

**dredwolf** · 03-15-2013, 11:24 PM

Maybe you could post your solution to help other members ?

And if your problem is solved, could you mark the thread solved? (top of page,thread tools, mark as solved)