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" <[email protected]> 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" <[email protected]> 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" <[email protected]> skrev i melding
news:%[email protected]...
> > 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 / ?
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 / ?
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" <[email protected]> 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" <[email protected]> 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 / ?
> >
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
On 3 Aug 2006 17:32:37 -0700, "Pete_UK" <[email protected]> wrote:
>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" <[email protected]> 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 / ?
>> >
M+ = memory plus
"miniman" <[email protected]> skrev i melding
news:[email protected]...
> 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
:-)
Aaron????
Or maybe Stephen Hawking???
Harald Staff wrote:
>
> "miniman" <[email protected]> skrev i melding
> news:[email protected]...
> > 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
> :-)
--
Dave Peterson
LOL. Definitely good ol' Stephen.
"Dave Peterson" <[email protected]> skrev i melding
news:[email protected]...
> Aaron????
>
> Or maybe Stephen Hawking???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks