cubic

M

miniman

Hi,

I am new to this thing of cubic.

How the cubic feature works in excel?

I am asking this because I saw a program on tv but i didn't see it from the
begining and it was saying something about formulas and how to work cubic sq
in excel!

And to let you know I 've been using excel for few months now!

Thanks in advance
 
G

Gord Dibben

Not sure what you're after.

Do you want a number cubed?

=2^3 returns 8

=4^3 returns 64

If something else, re-post with a different description.




Hi,

I am new to this thing of cubic.

How the cubic feature works in excel?

I am asking this because I saw a program on tv but i didn't see it from the
begining and it was saying something about formulas and how to work cubic sq
in excel!

And to let you know I 've been using excel for few months now!

Thanks in advance

Gord Dibben MS Excel MVP
 
M

miniman

Yes i know that I am a bit lost over this question!

I think there is a feature that excel works the cubic area for you!

For example you write Length x Width x Height of area and excel works it
out!
 
G

Gord Dibben

You mean some sort of worksheet function?

I don't know of one.

I would use =10*10*10 which returns 100 cubic whatevers

OR you could use =A1*B1*C1 where each of those cells held a number.


Gord Dibben MS Excel MVP
 
M

miniman

I would use =10*10*10 which returns 100 cubic whatevers

You mean Excel works it out for you?
 
H

Harald Staff

Yes, Excel works out what you ask her to work out. You never used formulas
in Excel before, or you don't understand math ? Please explain.

Best wishes Harald
 
D

Dave Peterson

If you're measuring the size of a carpet to fit your rectangular living room,
you multiply the length by the width to get square measurements.

If your living room is 18 feet long by 15 feet wide, you could enter this in one
cell:
=18*15
and you'll see 270
This is 270 square feet.

You could also put 18 in A1 and 15 in B1 and this in C1:
=a1*b1
and you'll see the same 270 in C1 after you hit enter.
Excel will do the math for you.

If you measured incorrectly, say that 15 feet should be 16 feet, you can just
change B1 to 16 and excel will reevaluate the formula in C1 and show you 288
(288 square feet).

========
On the other hand, if you're measuring how many cubic feet you have in your
living room, it's length times width times height.

If your living room is 18 feet long by 16 feet wide by 8 feet high, you could
use:

=18*16*8
and see 2304 CUBIC feet

You could put
18 in A1
16 in B1
8 in C1
and this in D1
=a1*b1*c1
and also see 2304 (cubic feet).

And if you wanted to, you could change A1, B1, C1 to different measurements and
D1 will react to your change.

Square feet for 2 dimensions (length by width)
Cubic feet for 3 dimensions (length by width by height)
 
M

miniman

Oh yes, very interesting!

2 more questions pls!

1) Is it possible to work with M+ as a calculator?

2) And is it possible to wotk with -, + and / ?
 
G

Gord Dibben

What is M+

Yes you can work with mathematical signs.

=1+1 returns 2.....adding

=2-1 returns 1....subtracting

=4/2 returns 2........dividing

=2*2 returns 4......multiplying


All formulas must be started with the = sign


Gord
 
P

Pete_UK

I think M+ is where you add a constant that has been stored in the
calculator's memory (a very old calculator! The first one I owned had
that feature).

Yes, you could put the number 15 in cell M1 and then in another cell
you could refer to M1 and it would take the value of 15, e.g. entering
this in cell A1:

= 2 * M1

would show 30 as the result.

Hope this helps.

Pete
 
G

Gord Dibben

Thanks for the refresh Pete.

I knew I had seen the M+ somewhere but forgot all about the couple of
Calculators I once owned.


Gord
 
H

Harald Staff

miniman said:
Oh yes, very interesting!
1) Is it possible to work with M+ as a calculator?
2) And is it possible to wotk with -, + and / ?

This has to be someone like Harlan pulling multiple legs. Good work my man
:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top