Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
21555 Online
bravocompany bravocompany bravocompany
brownells brownells
tnvc tnvc tnvc
AR15.COM
bravocompany
My Account
bravocompany bravocompany bravocompany
brownells brownells
tnvc tnvc tnvc
colt
palmetto
JRH
springfield
geissele
cz
midwest
bravocompany
RS
silencerShop
GS
aim
vortex
brownells
OSIGHT
primaryArms
skd
Holosun
magpul
Guns
fightlite
DFC
21555 Online
springfield
brownells
fightlite
colt
aim
palmetto
skd
JRH
vortex
primaryArms
RS
cz
GS
geissele
DFC
OSIGHT
Guns
bravocompany
Holosun
magpul
silencerShop
midwest
Site News Could You Have Stopped This? Vegas Shooting Analysis with Attorneys on Retainer
9/21/2010 1:30:12 PM EDT
For my college Business Computing Apps class i have been asked to write a formula that computes the decimal equivalent of a 5-digit octal value in cells A10 through E10 in excel.  

I know how to compute the number (taking the long route), but I believe my professor wants a short, to the point, formula.  

Thanks for the help!

DtheV
9/21/2010 1:33:54 PM EDT
[#1]
AutoSum
9/21/2010 1:36:30 PM EDT
[#2]
So something like =SUM(A10:E10) ???
9/21/2010 1:37:32 PM EDT
[#3]
Depending on your version of Excel, does =OCT2DEC(1225) work?
9/21/2010 1:40:22 PM EDT
[#4]
Mak

That results in 661.  I believe the correct answer should be 5349.  

We are going from octal to decimal.

EDIT:  I have Microsoft Excel 2007
9/21/2010 1:40:46 PM EDT
[#5]
Is there a separate octal number in each cell to convert individually, or is the assignment to find the sum of an octal number in each cell, then convert that to decimal?

9/21/2010 1:42:05 PM EDT
[#6]
You should be able to just use the formula =oct2dec(enter the cell of your oct number here) then enter. Fill this formula down to whatever cells you want.
9/21/2010 1:42:37 PM EDT
[#7]
I'll try this.  I will report back.
9/21/2010 1:44:26 PM EDT
[#8]
=oct2dec () WORKS!  Thanks guys!
9/21/2010 1:50:19 PM EDT
[#9]
Excellent! Do we get partial credit for the class?
9/21/2010 1:51:50 PM EDT
[#10]
Mak-

I'll ask my prof.  I somehow think using outside resources (such as a gun lovin forum) is against academic policy.  Hheehehhehe.
9/21/2010 1:53:24 PM EDT
[#11]



Quoted:


Mak-



I'll ask my prof.  I somehow think using outside resources (such as a gun lovin forum) is against academic policy.  Hheehehhehe.


Pfft...you could have found it in the "Help" section in Excel. Lazy bastard



 
9/21/2010 1:56:09 PM EDT
[#12]
After further analysis...I think my prof requires a different equation using row absolute and column absolute references.  Ugh.  I guess i'll just ask my prof tonight.

Thanks guys
9/21/2010 2:01:52 PM EDT
[#13]
Here is the problem.

http://i516.photobucket.com/albums/u323/DtheV17/A31.jpg

Notice 1 2 3 4 5 is my make up octal number (you should be able to put any numbers in...the formula should work).  The numbers below them are the octal numbers. First number is 1, followed by 8, 64, etc.  I am supposed to multiply A9 by A10, then carry it through to all the cells.  At the end i have to Auto sum it =SUM(A11:E11).

I'm just not sure how to create a concise formula outta it (if there is a short formula..i can make a long one)
9/21/2010 2:16:47 PM EDT
[#14]
Here's a short formula.

=SUM(+A10*4096,B10*512,C10*64,D10*8,E10*1)

Here's the short formula with absolute references

=SUM(+$A$10*4096,$B$10*512,$C$10*64,$D$10*8,$E$10*1)

I'm not sure I see the need for absolutes, but ok.

YMMV.

And I want extra credit!
9/21/2010 2:22:01 PM EDT
[#15]
I've apparently stumbled into a non-english speaking thread.  I must go now.
9/21/2010 2:34:52 PM EDT
[#16]
Holy fuck Mak.  If I was gay i'd blow ya.  That's just beautiful!
9/21/2010 2:37:31 PM EDT
[#17]
This is the revised version Mak.

=SUM(A9*A10,B9*B10,C9*C10,D9*D10,E9*E10)  

I believe this is exactly what my prof is looking for.  THANKS A BUNCH!
9/21/2010 2:41:52 PM EDT
[#18]
Quoted:
After further analysis...I think my prof requires a different equation using row absolute and column absolute references.  Ugh.  I guess i'll just ask my prof tonight.



If you *need* absolute references, your revised formula doesn't include them. Try copying & pasting your formula in 5 different spots on the spreadsheet? do you get the same result?

If you copied & pasted the absolute reference, you should get the same result regardless of where it's posted. Give it a try.

9/21/2010 2:42:48 PM EDT
[#19]
Quoted:
This is the revised version Mak.

=SUM(A9*A10,B9*B10,C9*C10,D9*D10,E9*E10)  

I believe this is exactly what my prof is looking for.  THANKS A BUNCH!


I expect he'll accept payment in the form of a new in wrapper magazine.

9/21/2010 2:43:58 PM EDT
[#20]
Quoted:
Quoted:
This is the revised version Mak.

=SUM(A9*A10,B9*B10,C9*C10,D9*D10,E9*E10)  

I believe this is exactly what my prof is looking for.  THANKS A BUNCH!


I expect he'll accept payment in the form of a new in wrapper magazine.



Make that 2 mags, 30 round. (I'll give you a 50% commission for brokering the deal)
9/21/2010 2:45:20 PM EDT
[#21]
9/21/2010 2:47:39 PM EDT
[#22]
On second thought...A blowjob would be easier/cheaper
9/21/2010 2:52:23 PM EDT
[#23]
Nothing says loving, like a full magazine...or something like that.

Did you try the "copy the formula" thing yet?
9/21/2010 2:55:04 PM EDT
[#24]
Mak-

I did!  Cool stuff.  THANKS FOR THE HELP!!!!!

9/21/2010 2:58:12 PM EDT
[#25]
No prob. Shipping address for mags coming via mail.

/goes to sit by Mailbox/
/waits/


/waits/


/waits/
9/21/2010 2:59:18 PM EDT
[#26]
Quoted:
No prob. Shipping address for mags coming via mail.

/goes to sit by Mailbox/
/waits/


/waits/


/waits/


You'll get something in the mail.  Not sure it will be what you're expecting though
9/21/2010 3:00:03 PM EDT
[#27]
Quoted:

EDIT:  I have Microsoft Excel 2007


I hate Excel 2007.
9/21/2010 3:02:55 PM EDT
[#28]
Quoted:
Quoted:

EDIT:  I have Microsoft Excel 2007


I hate Excel 2007.


Explain
9/21/2010 3:34:20 PM EDT
[#29]
Quoted:
Quoted:
Quoted:

EDIT:  I have Microsoft Excel 2007


I hate Excel 2007.


Explain


2007 introduced the ribbon bar. Menu's don't work like they should! (Back in 1992, now get off my lawn!)
The file formats changed. Now, you have several files to keep track of,  hidden from you by the experts at M$. xlsx vs xls.

Just 2 things that bugged me about 2007.
blackhills
THBRD
fightlite
ar15com
Pro2A
bravocompany
springfield
RS
LAPG
colt
Faxxon
brownells
palmetto
LAPG
cmmg
primaryArms
CA
geissele
gray
silencerShop
ar15com
SAS