Overclock.net › Forums › Software, Programming and Coding › Other Software › Microsoft Excel: Need help using it, please.
New Posts  All Forums:Forum Nav:

Microsoft Excel: Need help using it, please.

post #1 of 2
Thread Starter 
I need some assistance on how to setup something in Excel. I'm trying to do the following:

Start with 1,000 and add 200 each WEEK. I then need to add an interest rate to it (say 0.05%) each MONTH and then have it produce a total for that month. On top of that I need it to produce a total after a YEAR of it going.

Thanks in advance.
Phenom Power
(18 items)
 
  
CPUMotherboardGraphicsRAM
AMD FX-8350 BE ASUS M5A97 AM3+ 970 PNY GTX 780 3GB Crucial Ballistix Sport DDR3 1600 16GB 
Hard DriveHard DriveHard DriveOptical Drive
Seagate Barracuda 500GB 6Gb/s Samsung Spinpoint 750GB 3Gb/s Seagate Barracuda 2TB 6Gb/s LITE-ON DVD Burner SATA x2 
CoolingOSMonitorKeyboard
Cooler Master Hyper 212+ Windows 7 Professional x64 ACER LED 27" 1920 x 1080 Logitech Wave 
PowerCaseMouseMouse Pad
Corsair TX750 HAF 912 Logitech G5 RAZER eXactMat 
AudioOther
Logitech X-540 5.1 Surround Canon Pixma MG2200 
  hide details  
Reply
Phenom Power
(18 items)
 
  
CPUMotherboardGraphicsRAM
AMD FX-8350 BE ASUS M5A97 AM3+ 970 PNY GTX 780 3GB Crucial Ballistix Sport DDR3 1600 16GB 
Hard DriveHard DriveHard DriveOptical Drive
Seagate Barracuda 500GB 6Gb/s Samsung Spinpoint 750GB 3Gb/s Seagate Barracuda 2TB 6Gb/s LITE-ON DVD Burner SATA x2 
CoolingOSMonitorKeyboard
Cooler Master Hyper 212+ Windows 7 Professional x64 ACER LED 27" 1920 x 1080 Logitech Wave 
PowerCaseMouseMouse Pad
Corsair TX750 HAF 912 Logitech G5 RAZER eXactMat 
AudioOther
Logitech X-540 5.1 Surround Canon Pixma MG2200 
  hide details  
Reply
post #2 of 2
=fv(.05%/12,13,800,1000,0)
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 › Microsoft Excel: Need help using it, please.