Sheaitaintso's Baseball Corner!

Can someone help me with this excel formula?

Thanks in advance guys. What would the formula be on excel if I wanted to display “free” if baseball player is a free agent, “desirable” if the players batting average is over .300 and their age is at least 21 and displays “minors” for any player that doesnt fit in those categories?.All this assuming I have a spreadsheet with true false values for batting average, age, etc.

I think the only one that would be true false is the free agent question.
so a1 is player a free agent true false
b1 players batting average
c1 is players age
put on two lines due to yahoo punctuation cut off
=IF(and(A1=TRUE(),B1>299,C1>20),
“desirable”,”Minors”)
if you want though use your true false query
=IF(AND(A1=TRUE(),B1=TRUE(),C1=TRUE())
,”disireable”,”Minors”)
however if all 3 values are not good enough to make the desirable appear having it default to minors seems odd perhaps use ineligible

EZBalance Baseball Lineup Software demo.wmv

I Love spreadsheets Humor Baseball Jersey by CafePress I heart spreadsheets t-shirts and gifts for spreadsheets lovers…….

I LOVE SPREADSHEETS Baseball Jersey by CafePress I love spreadsheetsI heart spreadsheets…

Amazin’ Avenue Annual 2010: The premier fan guide to the 2010 New York Mets, featuring in-depth player profiles, prospect reports, team commentary & statistical analysis. $6.43 Please note, this is the black-and-white version of the Amazin’ Avenue Annual. A full-color version is also available. Amazin’ Avenue is the premier fan blog of the NY Mets. Renown for its online coverage of the Mets, Amazin’ Avenue regularly delivers exceptional analysis, timely news coverage, game chats, post-game commentary, and breakdowns of every transaction. Now, for the first time, the sam…

Progeek Rising: Steven Savage’s Best of Fan To Pro, Volume 1 $14.33 Steve Savage takes you back to the first year of www.fantopro.com, the blog for professional geeks, fans, and otaku. Journey back to yesteryear with the best (at least in his opinion) of his columns from 2008 to 2009 and explore issues ranging from relocating to the most fan-friendly areas, to brainstorming careers, to just what is the “Geekonomy.” It’s always a good time to go fan-to-pro!…

Scorebooth.com – Online Baseball & Softball Statistics Software $20.00 Scorebooth is a baseball and softball stats software program that is completely internet-based. It tracks, totals, calculates, and reports baseball or softball statistics as you enter results from your scorebook. If you currently use outdated software, a spreadsheet, or even pencil & paper to calculate your team’s stats – you will find that Scorebooth is an easier, more convenient option. Loaded…

Comments are closed.