Overclock.net › Forums › Software, Programming and Coding › Other Software › Excel Help (2010) #NUM! error.
New Posts  All Forums:Forum Nav:

Excel Help (2010) #NUM! error.

post #1 of 4
Thread Starter 
Hello,

I'm trying to make a table with decimal, hex, octal and binary numbers from 1 - 1024. Just a simple table to print out and pin in front of me.

I know the formulas i.e =DEC2BIN(A2), =DEC2OCT(A2) and =DEC2OCT(A2)

They'll do the maths for me and I can use the auto fill to complete the tables.

However, =DEC2BIN(A513) gives a #NUM! error, as do all the following calculations. Oh, A513 = 512

Any suggestions as to what to do? Life's to short to type the next 512 numbers in binary!


Thanks,

Mike
My do-it-all rig
(17 items)
 
  
CPUMotherboardGraphicsGraphics
AMD K15 970A-D3P NVIDIA GeForce GTX 660  NVIDIA GeForce GTX 460 
RAMRAMHard DriveOptical Drive
Kingston  Kingston  Crucial M4 64Gb, 4x 1Tb, 1x 500Gb WD Caviar Black LG LiteScribe GH24 
OSMonitorKeyboardPower
Win 10 x64 LG E2350 23" 1920x1080 / Samsung 19.5" 1366x768 Razer Lycosa (Mirror Edition) Corsair HX850w 
CaseMouseMouse PadAudio
CoolerMaster 690 Razer Mamba 2012 Razer Goliath XL Logitech X-530 speakers 
Audio
Creative SupremeFX X-Fi sound card 
  hide details  
Reply
My do-it-all rig
(17 items)
 
  
CPUMotherboardGraphicsGraphics
AMD K15 970A-D3P NVIDIA GeForce GTX 660  NVIDIA GeForce GTX 460 
RAMRAMHard DriveOptical Drive
Kingston  Kingston  Crucial M4 64Gb, 4x 1Tb, 1x 500Gb WD Caviar Black LG LiteScribe GH24 
OSMonitorKeyboardPower
Win 10 x64 LG E2350 23" 1920x1080 / Samsung 19.5" 1366x768 Razer Lycosa (Mirror Edition) Corsair HX850w 
CaseMouseMouse PadAudio
CoolerMaster 690 Razer Mamba 2012 Razer Goliath XL Logitech X-530 speakers 
Audio
Creative SupremeFX X-Fi sound card 
  hide details  
Reply
post #2 of 4
It looks like Excel can only go so far with the Binary function :/


Link
Nightwing
(27 items)
 
  
CPUMotherboardGraphicsGraphics
i7 950 Asus P6X58D-E MSI 390x Gaming 8 GB  XFX Radeon HD 5870 
GraphicsRAMHard DriveHard Drive
MSI 290X Lightning G.SKILL PI Series 6GB WD Caviar Black HDD Crucial C300 SSD 
Hard DriveOptical DriveCoolingCooling
Clickfree External HDD HP BD240I Blu Ray Combo Drive Corsair H70 with GT AP-15's in Push/Pull Intake... Scythe Kama Flex SA1325FDB12H Case Fan 
OSMonitorKeyboardPower
Windows 7 64 bit Ultimate Edition Alienware Optx AW2310 Deck Legend - Ice - Linear PS/2 Interface Corsair AX750 Modular Power Supply 
CaseMouseMouse PadAudio
Enthoo Luxe Logitech MX 518 Gaming-Grade Optical Mouse SteelSeries SX Game Pad Sound Blaster X-Fi Titanium HD  
AudioAudioOtherOther
Sennheiser HD 650 Schiit Magni Headphones Amplifier Logitech C905 Webcam Blue Yeti Microphone 
OtherOtherOther
Bose QC3 Headphones Creative 2.1 Speaker System Xbox 360 Wired Controller 
  hide details  
Reply
Nightwing
(27 items)
 
  
CPUMotherboardGraphicsGraphics
i7 950 Asus P6X58D-E MSI 390x Gaming 8 GB  XFX Radeon HD 5870 
GraphicsRAMHard DriveHard Drive
MSI 290X Lightning G.SKILL PI Series 6GB WD Caviar Black HDD Crucial C300 SSD 
Hard DriveOptical DriveCoolingCooling
Clickfree External HDD HP BD240I Blu Ray Combo Drive Corsair H70 with GT AP-15's in Push/Pull Intake... Scythe Kama Flex SA1325FDB12H Case Fan 
OSMonitorKeyboardPower
Windows 7 64 bit Ultimate Edition Alienware Optx AW2310 Deck Legend - Ice - Linear PS/2 Interface Corsair AX750 Modular Power Supply 
CaseMouseMouse PadAudio
Enthoo Luxe Logitech MX 518 Gaming-Grade Optical Mouse SteelSeries SX Game Pad Sound Blaster X-Fi Titanium HD  
AudioAudioOtherOther
Sennheiser HD 650 Schiit Magni Headphones Amplifier Logitech C905 Webcam Blue Yeti Microphone 
OtherOtherOther
Bose QC3 Headphones Creative 2.1 Speaker System Xbox 360 Wired Controller 
  hide details  
Reply
post #3 of 4
Thread Starter 
Quote:
Originally Posted by Gohan_Nightwing View Post

It looks like Excel can only go so far with the Binary function :/
Link

"If number < -512 or if number > 511, DEC2BIN returns the #NUM! error value."

Well, that sucks.

Thanks for the reply anyway...
My do-it-all rig
(17 items)
 
  
CPUMotherboardGraphicsGraphics
AMD K15 970A-D3P NVIDIA GeForce GTX 660  NVIDIA GeForce GTX 460 
RAMRAMHard DriveOptical Drive
Kingston  Kingston  Crucial M4 64Gb, 4x 1Tb, 1x 500Gb WD Caviar Black LG LiteScribe GH24 
OSMonitorKeyboardPower
Win 10 x64 LG E2350 23" 1920x1080 / Samsung 19.5" 1366x768 Razer Lycosa (Mirror Edition) Corsair HX850w 
CaseMouseMouse PadAudio
CoolerMaster 690 Razer Mamba 2012 Razer Goliath XL Logitech X-530 speakers 
Audio
Creative SupremeFX X-Fi sound card 
  hide details  
Reply
My do-it-all rig
(17 items)
 
  
CPUMotherboardGraphicsGraphics
AMD K15 970A-D3P NVIDIA GeForce GTX 660  NVIDIA GeForce GTX 460 
RAMRAMHard DriveOptical Drive
Kingston  Kingston  Crucial M4 64Gb, 4x 1Tb, 1x 500Gb WD Caviar Black LG LiteScribe GH24 
OSMonitorKeyboardPower
Win 10 x64 LG E2350 23" 1920x1080 / Samsung 19.5" 1366x768 Razer Lycosa (Mirror Edition) Corsair HX850w 
CaseMouseMouse PadAudio
CoolerMaster 690 Razer Mamba 2012 Razer Goliath XL Logitech X-530 speakers 
Audio
Creative SupremeFX X-Fi sound card 
  hide details  
Reply
post #4 of 4
Hrmmmm

Check this part of their forum out:

forum

I personally don't understand it, but it may help you.
Nightwing
(27 items)
 
  
CPUMotherboardGraphicsGraphics
i7 950 Asus P6X58D-E MSI 390x Gaming 8 GB  XFX Radeon HD 5870 
GraphicsRAMHard DriveHard Drive
MSI 290X Lightning G.SKILL PI Series 6GB WD Caviar Black HDD Crucial C300 SSD 
Hard DriveOptical DriveCoolingCooling
Clickfree External HDD HP BD240I Blu Ray Combo Drive Corsair H70 with GT AP-15's in Push/Pull Intake... Scythe Kama Flex SA1325FDB12H Case Fan 
OSMonitorKeyboardPower
Windows 7 64 bit Ultimate Edition Alienware Optx AW2310 Deck Legend - Ice - Linear PS/2 Interface Corsair AX750 Modular Power Supply 
CaseMouseMouse PadAudio
Enthoo Luxe Logitech MX 518 Gaming-Grade Optical Mouse SteelSeries SX Game Pad Sound Blaster X-Fi Titanium HD  
AudioAudioOtherOther
Sennheiser HD 650 Schiit Magni Headphones Amplifier Logitech C905 Webcam Blue Yeti Microphone 
OtherOtherOther
Bose QC3 Headphones Creative 2.1 Speaker System Xbox 360 Wired Controller 
  hide details  
Reply
Nightwing
(27 items)
 
  
CPUMotherboardGraphicsGraphics
i7 950 Asus P6X58D-E MSI 390x Gaming 8 GB  XFX Radeon HD 5870 
GraphicsRAMHard DriveHard Drive
MSI 290X Lightning G.SKILL PI Series 6GB WD Caviar Black HDD Crucial C300 SSD 
Hard DriveOptical DriveCoolingCooling
Clickfree External HDD HP BD240I Blu Ray Combo Drive Corsair H70 with GT AP-15's in Push/Pull Intake... Scythe Kama Flex SA1325FDB12H Case Fan 
OSMonitorKeyboardPower
Windows 7 64 bit Ultimate Edition Alienware Optx AW2310 Deck Legend - Ice - Linear PS/2 Interface Corsair AX750 Modular Power Supply 
CaseMouseMouse PadAudio
Enthoo Luxe Logitech MX 518 Gaming-Grade Optical Mouse SteelSeries SX Game Pad Sound Blaster X-Fi Titanium HD  
AudioAudioOtherOther
Sennheiser HD 650 Schiit Magni Headphones Amplifier Logitech C905 Webcam Blue Yeti Microphone 
OtherOtherOther
Bose QC3 Headphones Creative 2.1 Speaker System Xbox 360 Wired Controller 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Excel Help (2010) #NUM! error.