New Posts  All Forums:Forum Nav:

Excel Question

post #1 of 9
Thread Starter 
Im trying to multiply about 300 cells all by 1.35%, but I dont want to make new cells, what formula can I use to just multiply every number by 1.35% and have it change the current value?
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
post #2 of 9
Thread Starter 
Need this done ASAP sorry for the early bump.
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
post #3 of 9
here it is:

type 1.35 in a cell
copy that cell
select the range of cells you want to multiply
right click and select paste special
select Multiply under Operation
Done
Alienware 15
(10 items)
 
  
CPUGraphicsRAMHard Drive
Intel i7-4710HQ 3.5GHz Nvidia GeForce GTX 970M 3GB 16GB (2x8GB) Crucial Ballistix 1600 MHz Crucial MX200 500GB SSD 
OSMouseMouse PadAudio
Windows 8.1 Razer DeathAdder Chroma SteelSeries Qck StarCraft II Creative Sound Core3D-EX Audio 
OtherOther
Creative Aurvana Live Headphones SteelSeries QcK Starcraft Heart of the Swarm Mo... 
  hide details  
Reply
Alienware 15
(10 items)
 
  
CPUGraphicsRAMHard Drive
Intel i7-4710HQ 3.5GHz Nvidia GeForce GTX 970M 3GB 16GB (2x8GB) Crucial Ballistix 1600 MHz Crucial MX200 500GB SSD 
OSMouseMouse PadAudio
Windows 8.1 Razer DeathAdder Chroma SteelSeries Qck StarCraft II Creative Sound Core3D-EX Audio 
OtherOther
Creative Aurvana Live Headphones SteelSeries QcK Starcraft Heart of the Swarm Mo... 
  hide details  
Reply
post #4 of 9
Thread Starter 
Im trying to take that percentage off, I need this done by noon today! oh jeez
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
post #5 of 9
Thread Starter 
Bump due to time constraints HURRY PLEASE, I know bumps are supposed to be 24hrs but I have 3 hours to get this done !
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
post #6 of 9
:|

Just copy the 300 number cells you want to update (keep same order and the such) into another spreadsheet. Type '=A1/100*98.65' into cell B1, asuming your number data starts in cell A1, drag the B formula down the 300 lines, copy the 300 new values. Go back to your original sheet, paste the new values directly on top...

Other than that, I don't think excel will do same cell formulae as the values.. Unless you create a macro.

All that basic forumla does is divide by 100 (to get a 1% value) then multiplies by 98.65 (100-1.35) to get your value minus your 1.35%

Use the small square next to the cell to copy down the formula (not values)


Edit: I'm an Excel noob I know, but.. If it gets the job done, I'm not fussed how I've done it XD
Edited by ShadowEW - 8/23/11 at 6:34am
 
Rena [A6-4400M]
(12 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II 1090T [4.46GHz @ 1.472v] Gigabyte GA 790FXTA-UD5 [35C Ambient] Sapphire HD 6950 [Unlocked 1030/1500] Kingston HyperX [4x4GB / 1785MHz] 
Hard DriveHard DriveOptical DriveCooling
Mushkin Chronos Enhanced SSD [240GB] 9TB Storage Pioneer DVR-219L Corsair H100 [39C Idle/52C Load] 
OSMonitorKeyboardPower
Windows 8 x64 BenQ VW2420H Razer Blackwidow Antec CP850 
CaseMouseMouse PadAudio
Antec Twelve Hundred Sharkoon Fireglider Roccat Taito / Steelseries QcK C-Media CMI8738-MX - Videologic ZXR-500 
AudioAudioOtherOther
Logitech G930 Shure SRH240A Wacom Bamboo Pen and Touch Logitech Webcam Pro 9000 HD 
Other
Blue Microphones Snowflake USB Microphone 
CPUMotherboardGraphicsRAM
AMD A6-4400M Samsung NP355V5C-A05UK AMD Radeon HD 7520G Corsair Vengeance 8GB 1866MHz 
Hard DriveOptical DriveOSMonitor
Samsung 830 Series 64 GB Super Multi Dual Layer Windows 7 Home Premium 15.6” HD LED Display 
KeyboardCaseMouseAudio
Built in Samsung 355V5C Touchpad 3W Stereo Speaker (1.5W x2) 
CPUMotherboardGraphicsGraphics
Intel i7-3930k C2 Gigabyte Ga-x79-up4 XFX HD7970 3GB DD OC XFX HD7970 3GB DD OC 
RAMHard DriveCoolingOS
Kingston 4x4GB Beast Series 2400MHz Mushkin Chronos Deluxe 240GB Corsair H100i Fedora 
PowerCaseAudioOther
XFX 850W Pro Series NZXT Phantom 630 White Creative Soundblaster Recon3D Fatal1ty Professi... Bitfenix Spectre Pro (200mm | Red) x4 
OtherOtherOtherOther
Bitfenix Alchemy 6Pin PCIe Extension (Orange/Bl... Bitfenix Alchemy Braided SATA Cable (Red/Black) x6 Bitfenix Spectre Pro (140mm | Red) x1 Bitfenix Spectre Pro (140mm | Orange) x3 
OtherOtherOtherOther
Bitfenix Spectre Pro (120mm | Orange) x1 Bitfenix Hydra (Spectre Pro LED Controller) x1 Bitfenix Alchemy 24Pin ATX Extension (Orange/Bl... Bitfenix Alchemy 8Pin EPS12V Extension (Orange/... 
Other
Bitfenix Alchemy 8Pin PCIe Extension (Orange/Bl... 
  hide details  
Reply
 
Rena [A6-4400M]
(12 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II 1090T [4.46GHz @ 1.472v] Gigabyte GA 790FXTA-UD5 [35C Ambient] Sapphire HD 6950 [Unlocked 1030/1500] Kingston HyperX [4x4GB / 1785MHz] 
Hard DriveHard DriveOptical DriveCooling
Mushkin Chronos Enhanced SSD [240GB] 9TB Storage Pioneer DVR-219L Corsair H100 [39C Idle/52C Load] 
OSMonitorKeyboardPower
Windows 8 x64 BenQ VW2420H Razer Blackwidow Antec CP850 
CaseMouseMouse PadAudio
Antec Twelve Hundred Sharkoon Fireglider Roccat Taito / Steelseries QcK C-Media CMI8738-MX - Videologic ZXR-500 
AudioAudioOtherOther
Logitech G930 Shure SRH240A Wacom Bamboo Pen and Touch Logitech Webcam Pro 9000 HD 
Other
Blue Microphones Snowflake USB Microphone 
CPUMotherboardGraphicsRAM
AMD A6-4400M Samsung NP355V5C-A05UK AMD Radeon HD 7520G Corsair Vengeance 8GB 1866MHz 
Hard DriveOptical DriveOSMonitor
Samsung 830 Series 64 GB Super Multi Dual Layer Windows 7 Home Premium 15.6” HD LED Display 
KeyboardCaseMouseAudio
Built in Samsung 355V5C Touchpad 3W Stereo Speaker (1.5W x2) 
CPUMotherboardGraphicsGraphics
Intel i7-3930k C2 Gigabyte Ga-x79-up4 XFX HD7970 3GB DD OC XFX HD7970 3GB DD OC 
RAMHard DriveCoolingOS
Kingston 4x4GB Beast Series 2400MHz Mushkin Chronos Deluxe 240GB Corsair H100i Fedora 
PowerCaseAudioOther
XFX 850W Pro Series NZXT Phantom 630 White Creative Soundblaster Recon3D Fatal1ty Professi... Bitfenix Spectre Pro (200mm | Red) x4 
OtherOtherOtherOther
Bitfenix Alchemy 6Pin PCIe Extension (Orange/Bl... Bitfenix Alchemy Braided SATA Cable (Red/Black) x6 Bitfenix Spectre Pro (140mm | Red) x1 Bitfenix Spectre Pro (140mm | Orange) x3 
OtherOtherOtherOther
Bitfenix Spectre Pro (120mm | Orange) x1 Bitfenix Hydra (Spectre Pro LED Controller) x1 Bitfenix Alchemy 24Pin ATX Extension (Orange/Bl... Bitfenix Alchemy 8Pin EPS12V Extension (Orange/... 
Other
Bitfenix Alchemy 8Pin PCIe Extension (Orange/Bl... 
  hide details  
Reply
post #7 of 9
Thread Starter 
SOLVED THANKS, I called my boss and he just wanted it increased not decreased thanks dutch!
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
post #8 of 9
Thread Starter 
Quote:
Originally Posted by ShadowEW View Post
:|

Just copy the 300 number cells you want to update (keep same order and the such) into another spreadsheet. Type '=A1/100*98.65' into cell B1, asuming your number data starts in cell one, drag the B formula down the 300 lines, copy the 300 new values. Go back to your original sheet, paste the new values directly on top...

Other than that, I don't think excel will do same cell formulae as the values.. Unless you create a macro.
I did this and then he called me and told me to just increase it, lol
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
My PC
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS P8Z77-V PRO EVGA GTX 670 FTW Ed. Corsair XMS3 8GB DDR3 1600MHZ 
Hard DriveOptical DriveOSMonitor
Crucial M4 64GB, WD 640GB, Spinpoint F3 1TB LG Windows 7 Ultimate 64 Bit 3X ASUS 23'' 1080p HDMI 6056x1080 
KeyboardPowerCaseMouse
Ducky Shine Cherry MX Blues Corsair HX-750W HAF 932 Black Logitech G500 
Mouse Pad
CM Weapon Of Choice 
  hide details  
Reply
post #9 of 9
Quote:
Originally Posted by Theory View Post
I did this and then he called me and told me to just increase it, lol


Glad to know you solved the problem, you should of phoned last week and not left it to the last minute XD
 
Rena [A6-4400M]
(12 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II 1090T [4.46GHz @ 1.472v] Gigabyte GA 790FXTA-UD5 [35C Ambient] Sapphire HD 6950 [Unlocked 1030/1500] Kingston HyperX [4x4GB / 1785MHz] 
Hard DriveHard DriveOptical DriveCooling
Mushkin Chronos Enhanced SSD [240GB] 9TB Storage Pioneer DVR-219L Corsair H100 [39C Idle/52C Load] 
OSMonitorKeyboardPower
Windows 8 x64 BenQ VW2420H Razer Blackwidow Antec CP850 
CaseMouseMouse PadAudio
Antec Twelve Hundred Sharkoon Fireglider Roccat Taito / Steelseries QcK C-Media CMI8738-MX - Videologic ZXR-500 
AudioAudioOtherOther
Logitech G930 Shure SRH240A Wacom Bamboo Pen and Touch Logitech Webcam Pro 9000 HD 
Other
Blue Microphones Snowflake USB Microphone 
CPUMotherboardGraphicsRAM
AMD A6-4400M Samsung NP355V5C-A05UK AMD Radeon HD 7520G Corsair Vengeance 8GB 1866MHz 
Hard DriveOptical DriveOSMonitor
Samsung 830 Series 64 GB Super Multi Dual Layer Windows 7 Home Premium 15.6” HD LED Display 
KeyboardCaseMouseAudio
Built in Samsung 355V5C Touchpad 3W Stereo Speaker (1.5W x2) 
CPUMotherboardGraphicsGraphics
Intel i7-3930k C2 Gigabyte Ga-x79-up4 XFX HD7970 3GB DD OC XFX HD7970 3GB DD OC 
RAMHard DriveCoolingOS
Kingston 4x4GB Beast Series 2400MHz Mushkin Chronos Deluxe 240GB Corsair H100i Fedora 
PowerCaseAudioOther
XFX 850W Pro Series NZXT Phantom 630 White Creative Soundblaster Recon3D Fatal1ty Professi... Bitfenix Spectre Pro (200mm | Red) x4 
OtherOtherOtherOther
Bitfenix Alchemy 6Pin PCIe Extension (Orange/Bl... Bitfenix Alchemy Braided SATA Cable (Red/Black) x6 Bitfenix Spectre Pro (140mm | Red) x1 Bitfenix Spectre Pro (140mm | Orange) x3 
OtherOtherOtherOther
Bitfenix Spectre Pro (120mm | Orange) x1 Bitfenix Hydra (Spectre Pro LED Controller) x1 Bitfenix Alchemy 24Pin ATX Extension (Orange/Bl... Bitfenix Alchemy 8Pin EPS12V Extension (Orange/... 
Other
Bitfenix Alchemy 8Pin PCIe Extension (Orange/Bl... 
  hide details  
Reply
 
Rena [A6-4400M]
(12 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II 1090T [4.46GHz @ 1.472v] Gigabyte GA 790FXTA-UD5 [35C Ambient] Sapphire HD 6950 [Unlocked 1030/1500] Kingston HyperX [4x4GB / 1785MHz] 
Hard DriveHard DriveOptical DriveCooling
Mushkin Chronos Enhanced SSD [240GB] 9TB Storage Pioneer DVR-219L Corsair H100 [39C Idle/52C Load] 
OSMonitorKeyboardPower
Windows 8 x64 BenQ VW2420H Razer Blackwidow Antec CP850 
CaseMouseMouse PadAudio
Antec Twelve Hundred Sharkoon Fireglider Roccat Taito / Steelseries QcK C-Media CMI8738-MX - Videologic ZXR-500 
AudioAudioOtherOther
Logitech G930 Shure SRH240A Wacom Bamboo Pen and Touch Logitech Webcam Pro 9000 HD 
Other
Blue Microphones Snowflake USB Microphone 
CPUMotherboardGraphicsRAM
AMD A6-4400M Samsung NP355V5C-A05UK AMD Radeon HD 7520G Corsair Vengeance 8GB 1866MHz 
Hard DriveOptical DriveOSMonitor
Samsung 830 Series 64 GB Super Multi Dual Layer Windows 7 Home Premium 15.6” HD LED Display 
KeyboardCaseMouseAudio
Built in Samsung 355V5C Touchpad 3W Stereo Speaker (1.5W x2) 
CPUMotherboardGraphicsGraphics
Intel i7-3930k C2 Gigabyte Ga-x79-up4 XFX HD7970 3GB DD OC XFX HD7970 3GB DD OC 
RAMHard DriveCoolingOS
Kingston 4x4GB Beast Series 2400MHz Mushkin Chronos Deluxe 240GB Corsair H100i Fedora 
PowerCaseAudioOther
XFX 850W Pro Series NZXT Phantom 630 White Creative Soundblaster Recon3D Fatal1ty Professi... Bitfenix Spectre Pro (200mm | Red) x4 
OtherOtherOtherOther
Bitfenix Alchemy 6Pin PCIe Extension (Orange/Bl... Bitfenix Alchemy Braided SATA Cable (Red/Black) x6 Bitfenix Spectre Pro (140mm | Red) x1 Bitfenix Spectre Pro (140mm | Orange) x3 
OtherOtherOtherOther
Bitfenix Spectre Pro (120mm | Orange) x1 Bitfenix Hydra (Spectre Pro LED Controller) x1 Bitfenix Alchemy 24Pin ATX Extension (Orange/Bl... Bitfenix Alchemy 8Pin EPS12V Extension (Orange/... 
Other
Bitfenix Alchemy 8Pin PCIe Extension (Orange/Bl... 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software