Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

I NEED HELP WITH MY FANTASY FOOT BALL BUDGET TRACKER

0

ok so i need to figure out how to get my max bid amount to work i can enter data in and the budget does drop down from 200 in accordance with what I enter. But i am a dummy when it comes to excel, my goal is to enter in data and see the 200 dollar budget amount decrease along with the max bid amount, so i have 12 teams and 22 roster spots that need at least 1 dollar amout, For example if I have 3 players for a total of 21 dollars I would like the budget to drop to 179 and the max bid amount to drop to 160 if that makes sence if i did my math correctly this is why i need excel please be very discriptive and in lamemans terms thanks again. 

Answer
Discuss

Discussion

You will have to include a sample file that illustrates what you are trying to do and then someone can give you some simple formulas that should do everything without an issue. I am not familiar with a gambling style spreadsheet so I really wouldn't know where to begin in helping you design the template.
don (rep: 1989) Aug 23, '16 at 11:14 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login