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

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.




On Thu, 3 Aug 2006 19:10:16 +0200, "miniman" <(E-Mail Removed)> wrote:

>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

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!

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

On Thu, 3 Aug 2006 20:13:13 +0200, "miniman" <(E-Mail Removed)> wrote:

>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!
>

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

You mean Excel works it out for you?

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

"miniman" <(E-Mail Removed)> skrev i melding
news:%(E-Mail Removed)...
> > I would use =10*10*10 which returns 100 cubic whatevers
>
> You mean Excel works it out for you?
>
>

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)


miniman wrote:
>
> 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

--

Dave Peterson

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 / ?

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

On Thu, 3 Aug 2006 22:11:04 +0200, "miniman" <(E-Mail Removed)> wrote:

>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 / ?
>

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

Gord Dibben wrote:
> 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
>
> On Thu, 3 Aug 2006 22:11:04 +0200, "miniman" <(E-Mail Removed)> wrote:
>
> >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 / ?
> >