Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
6000 Online
bravocompany bravocompany bravocompany
brownells brownells
tnvc tnvc tnvc
AR15.COM
bravocompany
My Account
bravocompany bravocompany bravocompany
brownells brownells
tnvc tnvc tnvc
JRH
cz
midwest
colt
Guns
GS
DFC
palmetto
aim
silencerShop
brownells
geissele
springfield
magpul
fightlite
vortex
OSIGHT
skd
Holosun
RS
primaryArms
bravocompany
6000 Online
silencerShop
JRH
geissele
primaryArms
magpul
RS
bravocompany
skd
springfield
fightlite
GS
palmetto
aim
vortex
midwest
DFC
colt
cz
brownells
Holosun
Guns
OSIGHT
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.
ar15com
bravocompany
RS
THBRD
colt
primaryArms
LAPG
palmetto
blackhills
geissele
gray
LAPG
SAS
ar15com
Faxxon
cmmg
silencerShop
CA
springfield
Pro2A
brownells
ar15com