DCSportbikes.net  
» Help Support .NET!
DCSportbikes Premier Membership for 25$ per year. Discounts! Click here for full information.

Now available in the .NET Shop:



Get your DCSBN Gear!
» Shoutbox
Sorry, only registered users have the ability to use our real-time shoutbox to chat with other members.

Register now, it's free!
» Online Users: 469
3 members and 466 guests
davidcycle, legendindisguise, nootherids
Most users ever online was 4,519, September 2, 2015 at 03:26 AM.
Go Back   DCSportbikes.net > Non-Sportbike Forums > Non-Sportbike Chat

Reply
LinkBack Thread Tools
Serious Question....Who knows excel...trying to do this budget
Unread
  (#1)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
Serious Question....Who knows excel...trying to do this budget - October 5, 2011, 09:55 AM

Alright so I am trying to do this budget. I decided to try a new way of budgeting since I just switch over to PNC Virtual Wallet(Fantastic by the way if you looking to get away fro that Wachovia pop cockery).

Anyways this is a picture of the excel I am working with. What I am trying to do is since direct deposit goes to the reserve account, I want to be able to move money to spending and growth. Now I want to basically do this by only inputing numbers and a variable in excel and let it do the magic. So spending is represented by the letter S, Reserve R, and growth G.

So what I want to do is when I get direct deposit, put -1000, S and it adds that 1000 to Spending and subtracts it from the Reserve. Same for Growth. IF G is found between (A21:A32), take that amount and add it to the specified location.

**Anyone know how to do this. I know they have FIND and SUMIF but cant get it working.


EDIT = Added the zip with the excel for anyone who whats to play...




Attached Files
File Type: zip Budget 2011.zip (10.1 KB, 0 views)


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions

Last edited by bds120; October 5, 2011 at 09:58 AM..
  Send a message via AIM to  
Reply With Quote
Unread
  (#2)
SRWJTS Recruiter
 
ReasonableDoubt's Avatar
 
Posts: 2,416
Join Date: August 18, 2010
Location: Fairfax, VA
October 5, 2011, 09:58 AM

Excel Formulas/Formulae. Microsoft Excel Formulas (Formulae) & Tips/Tricks

What you're trying to do isn't that complicated, just a few add/subtract formulas.

Learn Excel so you can put it on your resume


"Remember you may love your bike but your bike doesn't love you and that bitch will kill you the first time you do her wrong."

MARRC Cornerworker
http://www.marrc.org/

2010 Triumph Daytona 675 SE
2006 Yamaha R6 - Anniversary Edition - SOLD
2005 Yamaha R6 - SOLD
2001 Yamaha YZF600R - SOLD
  Send a message via AIM to  
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Powered by vBadvanced CMPS v3.2.3


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
vBulletin Skin developed by: vBStyles.com
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest 2002-2010 by DCSportbikes.net. DCSportbikes.net is owned by End of Time Studios, LLC.