Using excel for maths!

**robertall** · 29-07-2005, 17:02

Maths tutorial.

The first thing I will start with is how to use adding and subtracting in excel.

Let?s say we have 15 in the box named ?a1? and 22 in the box known as ?a2?. To add these together we just put =a1+a2 in another box. When you leave the box, you will notice that the 2 numbers are added together. The answer is 37.

1. Put a random number in a1
2. Put a random number in a2
3. Put in any other box =a1+a2
4. Your answer will appear.

You can use any of the other things below.
+ (add)
- (subtract)
/ (divide)
* (multiply)

Let?s see what we know. You can use excel to do everyday maths. There was a much bigger purpose to excel. If you know more advanced maths it can be very useful. It will also work well on old computers, because no matter how big the sum, it should be able to cope.

π = 3.14

With the above knowledge, we can create loads of great things. The first thing is that we have the simple code to radius. This can be used to work out the surface area. This is very complex, and if you do not understand maths I would recommend skipping this step.

V=Volume
R = Radius
H = height
SA = Surface area

1. Put the letter ?v? in a1.
2. Put the letter ?r? in b1.
3. Put the letter ?h? in c1.
4. Put the letters ?SA? in d1.
5. In a2, type the number ?1000? and then at the bottom right of that square is a little +. Drag that down to a100.
6. In b2 put the number ?1?. Then in b3 put ?=B2+0.1? and then drag that down to b100 using the bottom right ?+?.

The next part is when use the pi to work out the height of the ?object?. Notice that there is only one variable instead of 2. This is so that it works and so that you do not get loads of different results.

7. In c2 type ?=A2/(3.14*B2^2)?.

You will notice that pi is being multiplied with b2. Then the whole sum is divided by a2. This works out only the height.

8. Drag c2 to c100
9. In D2 type ?=2*3.14*B2^2+2*3.14*B2*C2?

This first thing. The radius is only 3.14, to make it the circumference we have to double the value. Then we multiply the new doubled pi to b2. The ?^? means the power to x, in this case B2 to the power 2. Then that adds with 2* pi. Again that is because of radius and other things. Then b2 and c2 are multiplied.

Was this useful?
[break]
I have added a download to the work above. You can find it below.

http://www.image4you.org/per-files/mathswork1demo.xls

Hotlink protect is off so right click it and then click "save link target as..."

randomman · 29-07-2005, 17:44

this is a lovely tut but i got taught how to use it at school (about the only thing i learned there) maybe because my school thinks i may actually use excel one day cough cough

**robertall** · 29-07-2005, 20:11

I also learned it at school, but i got so bored i made a tutorial from it.

randomman · 30-07-2005, 12:58

I HATE EXCEL,its worse than firefox and thats saying something

**robertall** · 30-07-2005, 18:05

Quote:

Originally Posted by randomman

I HATE EXCEL,its worse than firefox and thats saying something

Lol. In otherwords it is very good then. Better than IE. Firefox is by far the best browser, so this one must be... ...second best.

01wojtowicz · 30-07-2005, 23:22

then at the bottom right of that square is a little +.

i just thought id tell you that this is the "fill handle"

randomman · 31-07-2005, 10:15

firefox is worse than rBrowser and thats saying something

FrozenDice · 01-08-2005, 08:16

Excel is one of the most usefull tools you'll find on any computer, for math and physics that is anyway. Durring my first physics course I used excel for every report to plot and fix my graphs to find corelations.

People that didn't know how to use excel had to do it by hand which was really funny.

Whats really usefull is to make a template spreadsheet where you have forumulas for common math problems already in. Just keep your laptop open durring class and you'll find yourself not having to do the small problems that take up alot of time. When you get to a peice that can be done by excel just punch it into the appropreate slot and you just saved a min.

29-07-2005, 17:02	#1 (permalink)
robertall Moderator Join Date: Jan 2005 Location: post is there >> Posts: 1,586 iTrader: 0 / 0%	Using excel for maths! Maths tutorial. The first thing I will start with is how to use adding and subtracting in excel. Let?s say we have 15 in the box named ?a1? and 22 in the box known as ?a2?. To add these together we just put =a1+a2 in another box. When you leave the box, you will notice that the 2 numbers are added together. The answer is 37. 1. Put a random number in a1 2. Put a random number in a2 3. Put in any other box =a1+a2 4. Your answer will appear. You can use any of the other things below. + (add) - (subtract) / (divide) * (multiply) Let?s see what we know. You can use excel to do everyday maths. There was a much bigger purpose to excel. If you know more advanced maths it can be very useful. It will also work well on old computers, because no matter how big the sum, it should be able to cope. π = 3.14 With the above knowledge, we can create loads of great things. The first thing is that we have the simple code to radius. This can be used to work out the surface area. This is very complex, and if you do not understand maths I would recommend skipping this step. V=Volume R = Radius H = height SA = Surface area 1. Put the letter ?v? in a1. 2. Put the letter ?r? in b1. 3. Put the letter ?h? in c1. 4. Put the letters ?SA? in d1. 5. In a2, type the number ?1000? and then at the bottom right of that square is a little +. Drag that down to a100. 6. In b2 put the number ?1?. Then in b3 put ?=B2+0.1? and then drag that down to b100 using the bottom right ?+?. The next part is when use the pi to work out the height of the ?object?. Notice that there is only one variable instead of 2. This is so that it works and so that you do not get loads of different results. 7. In c2 type ?=A2/(3.14B2^2)?. You will notice that pi is being multiplied with b2. Then the whole sum is divided by a2. This works out only the height. 8. Drag c2 to c100 9. In D2 type ?=23.14B2^2+23.14B2C2? This first thing. The radius is only 3.14, to make it the circumference we have to double the value. Then we multiply the new doubled pi to b2. The ?^? means the power to x, in this case B2 to the power 2. Then that adds with 2* pi. Again that is because of radius and other things. Then b2 and c2 are multiplied. Was this useful? [break] I have added a download to the work above. You can find it below. http://www.image4you.org/per-files/mathswork1demo.xls Hotlink protect is off so right click it and then click "save link target as..." __________________ Free .org domain - Click for details! Do not pm asking for things. My inbox is full. Add me to MSN!

29-07-2005, 20:11	#3 (permalink)
robertall Moderator Join Date: Jan 2005 Location: post is there >> Posts: 1,586 iTrader: 0 / 0%	I also learned it at school, but i got so bored i made a tutorial from it. __________________ Free .org domain - Click for details! Do not pm asking for things. My inbox is full. Add me to MSN!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import Microsoft Excel data to MySQL	monaghan	Php and MySQL	0	01-12-2005 13:44

30-07-2005, 23:22	#6 (permalink)
01wojtowicz me Join Date: Apr 2005 Location: Wiltshire Posts: 714 iTrader: 0 / 0%	then at the bottom right of that square is a little +. i just thought id tell you that this is the "fill handle"

01-08-2005, 08:16	#8 (permalink)
FrozenDice Senior Member Join Date: Jun 2005 Posts: 389 iTrader: 0 / 0%	Excel is one of the most usefull tools you'll find on any computer, for math and physics that is anyway. Durring my first physics course I used excel for every report to plot and fix my graphs to find corelations. People that didn't know how to use excel had to do it by hand which was really funny. Whats really usefull is to make a template spreadsheet where you have forumulas for common math problems already in. Just keep your laptop open durring class and you'll find yourself not having to do the small problems that take up alot of time. When you get to a peice that can be done by excel just punch it into the appropreate slot and you just saved a min.

Using excel for maths!

Using excel for maths!

Similar Threads