Overclock.net › Forums › Software, Programming and Coding › Other Software › Excel users: I. AM. STUMPED.
New Posts  All Forums:Forum Nav:

Excel users: I. AM. STUMPED.

post #1 of 8
Thread Starter 
I need to calculate a change in percent of 2 numbers.

I have $13,577.40 in cell A1, and $18 in cell A2. Vast difference, but I will not disclose what the numbers are.

My function is set up as such: (A2-A1)/A1 and the result is -99.87%.

Using online calculators, specifically this one, gives me this result: 0.13257324671881215%


In short... What am I doing wrong?
    
CPUMotherboardGraphicsRAM
Q8400 DFI LP DK P45-T2RS eVGA GTX 650 Kingston 
Hard DriveOptical DriveOSMonitor
2.8TB Total LG Super DVD Burner SATA VII Enterprise x64 Gateway FHD2401 
PowerCaseMouseMouse Pad
Corsair VX550W NZXT Source 210 White Logitech G400 Razer Kabuto 
Audio
Creative Audigy 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Q8400 DFI LP DK P45-T2RS eVGA GTX 650 Kingston 
Hard DriveOptical DriveOSMonitor
2.8TB Total LG Super DVD Burner SATA VII Enterprise x64 Gateway FHD2401 
PowerCaseMouseMouse Pad
Corsair VX550W NZXT Source 210 White Logitech G400 Razer Kabuto 
Audio
Creative Audigy 
  hide details  
Reply
post #2 of 8
Both are right , it is a matter of interpretation .
18 is 0.1325 % of 13 577 or -99.87 % less than 13 5777.
The box
(17 items)
 
  
CPUMotherboardGraphicsGraphics
Intel Core i7 4930K RAMPAGE IV FORMULA AMDKMDAP AMDKMDAP 
GraphicsRAMRAMRAM
AMDKMDAP Corsair  Corsair  Corsair  
  hide details  
Reply
The box
(17 items)
 
  
CPUMotherboardGraphicsGraphics
Intel Core i7 4930K RAMPAGE IV FORMULA AMDKMDAP AMDKMDAP 
GraphicsRAMRAMRAM
AMDKMDAP Corsair  Corsair  Corsair  
  hide details  
Reply
post #3 of 8
Thread Starter 
I understand, however, I need Excel to display 0.1325%.
    
CPUMotherboardGraphicsRAM
Q8400 DFI LP DK P45-T2RS eVGA GTX 650 Kingston 
Hard DriveOptical DriveOSMonitor
2.8TB Total LG Super DVD Burner SATA VII Enterprise x64 Gateway FHD2401 
PowerCaseMouseMouse Pad
Corsair VX550W NZXT Source 210 White Logitech G400 Razer Kabuto 
Audio
Creative Audigy 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Q8400 DFI LP DK P45-T2RS eVGA GTX 650 Kingston 
Hard DriveOptical DriveOSMonitor
2.8TB Total LG Super DVD Burner SATA VII Enterprise x64 Gateway FHD2401 
PowerCaseMouseMouse Pad
Corsair VX550W NZXT Source 210 White Logitech G400 Razer Kabuto 
Audio
Creative Audigy 
  hide details  
Reply
post #4 of 8
You could either just add 100 to that product or do:
(A2/A1)*100
post #5 of 8
Change your function to 100 + ( (A2 - A1) / A1 )
post #6 of 8
I don't understand... Do you want the percent change of (13577.4 - 18) and 13577.4? or 13577.4 and 18?

Copy and paste this and I'll get the percent that you're are looking for.

=A1/(A1-A2)-1

Like this:

Edited by age_ruler1 - 9/1/13 at 8:50pm
The Red Box
(14 items)
 
The Red Note
(5 items)
 
 
CPUGraphicsRAMHard Drive
Intel i5 3230M  NVIDIA GeForce GT 650M Sli 6GB 1TB + 16SSD cache 
OS
Windows 8 - 64Bits 
  hide details  
Reply
The Red Box
(14 items)
 
The Red Note
(5 items)
 
 
CPUGraphicsRAMHard Drive
Intel i5 3230M  NVIDIA GeForce GT 650M Sli 6GB 1TB + 16SSD cache 
OS
Windows 8 - 64Bits 
  hide details  
Reply
post #7 of 8
Quote:
Originally Posted by Raged-Daniel View Post

You could either just add 100 to that product or do:
(A2/A1)*100

Spot on. New value divided by old value then the quotient multiplied by 100. Or format a column or row as a percentage and just divide A2 by A1.

As a tip for most of those online calculators you can right click the page and view the source scroll through the code and you will usually find the form functions written out in the code. The one you mention in particular is down towards the bottom defined as function calc2(form). The code looks like this:

function calc2(form) {

a = form.c.value;
b = form.d.value;
c = a/b
d = c*100

form.total2.value = d:
}
Red-Scout
(18 items)
 
Asus G53SX-TH71
(12 items)
 
Big Blue
(12 items)
 
CPUMotherboardGraphicsGraphics
AMD 8320 FX Asus Crosshair V Twin Frozr 6950 Twin Frozr 6950 
RAMHard DriveHard DriveHard Drive
Corsair Vengence Red Crucial M4 Western Digital Raptor 300gb Western Digital 1 TB Black 
Optical DriveCoolingOSMonitor
LG Blu-ray Corsair H80 Windows 7 Professional Asus VE248H x3 
KeyboardPowerCaseMouse
Logitech MX 5500 Revolution Black Thermaltake TR2 RX 750w CoolerMaster Storm Scout MX Revolution Cordless Laser Mouse 
AudioAudio
Logitech X-540 5.1 System Creative Sound Blaster X-Fi Titanium Fatal1ty 
CPUMotherboardGraphicsRAM
Intel Core i7 2670QM G53SX NVIDIA GeForce GTX 560M Samsung  
RAMRAMRAMHard Drive
Corsair  Samsung  Corsair  Corsair Force GT3 
Hard DriveOptical DriveOSMonitor
Hitachi Blu-Ray Drive Windows 7 Professional 15.4" 1080p 
CPUMotherboardGraphicsRAM
AMD FX 8120 Asus M5A99FX Pro R2.0 MSI Windforce 6850 Kingston Hyper-Blue 16Gb 
Hard DriveHard DriveHard DriveCooling
3x Seagate Barracuda 3Tb OCZ Agility 2 64Gb 3x OCZ Vertex 2 Plus 32 Gb Cooler Master Seidon 120mm 
OSOSPowerCase
Windows Server 2012 Standard VMs (Server 2012, Windows 7, Windows 8, Ubuntu,... PC Power and Cooling 500w Silencer NXZT Switch 810 
  hide details  
Reply
Red-Scout
(18 items)
 
Asus G53SX-TH71
(12 items)
 
Big Blue
(12 items)
 
CPUMotherboardGraphicsGraphics
AMD 8320 FX Asus Crosshair V Twin Frozr 6950 Twin Frozr 6950 
RAMHard DriveHard DriveHard Drive
Corsair Vengence Red Crucial M4 Western Digital Raptor 300gb Western Digital 1 TB Black 
Optical DriveCoolingOSMonitor
LG Blu-ray Corsair H80 Windows 7 Professional Asus VE248H x3 
KeyboardPowerCaseMouse
Logitech MX 5500 Revolution Black Thermaltake TR2 RX 750w CoolerMaster Storm Scout MX Revolution Cordless Laser Mouse 
AudioAudio
Logitech X-540 5.1 System Creative Sound Blaster X-Fi Titanium Fatal1ty 
CPUMotherboardGraphicsRAM
Intel Core i7 2670QM G53SX NVIDIA GeForce GTX 560M Samsung  
RAMRAMRAMHard Drive
Corsair  Samsung  Corsair  Corsair Force GT3 
Hard DriveOptical DriveOSMonitor
Hitachi Blu-Ray Drive Windows 7 Professional 15.4" 1080p 
CPUMotherboardGraphicsRAM
AMD FX 8120 Asus M5A99FX Pro R2.0 MSI Windforce 6850 Kingston Hyper-Blue 16Gb 
Hard DriveHard DriveHard DriveCooling
3x Seagate Barracuda 3Tb OCZ Agility 2 64Gb 3x OCZ Vertex 2 Plus 32 Gb Cooler Master Seidon 120mm 
OSOSPowerCase
Windows Server 2012 Standard VMs (Server 2012, Windows 7, Windows 8, Ubuntu,... PC Power and Cooling 500w Silencer NXZT Switch 810 
  hide details  
Reply
post #8 of 8
Thread Starter 
Thank you all!

+Rep for everyone!
    
CPUMotherboardGraphicsRAM
Q8400 DFI LP DK P45-T2RS eVGA GTX 650 Kingston 
Hard DriveOptical DriveOSMonitor
2.8TB Total LG Super DVD Burner SATA VII Enterprise x64 Gateway FHD2401 
PowerCaseMouseMouse Pad
Corsair VX550W NZXT Source 210 White Logitech G400 Razer Kabuto 
Audio
Creative Audigy 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Q8400 DFI LP DK P45-T2RS eVGA GTX 650 Kingston 
Hard DriveOptical DriveOSMonitor
2.8TB Total LG Super DVD Burner SATA VII Enterprise x64 Gateway FHD2401 
PowerCaseMouseMouse Pad
Corsair VX550W NZXT Source 210 White Logitech G400 Razer Kabuto 
Audio
Creative Audigy 
  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 users: I. AM. STUMPED.