BE SURE TO CENTER ALL YOUR DATA....
As of right now you have built in:
Totals- =sum( : )
Average- =average ( : )
Now I want you to build in :
Max value =max ( : )
Min value =min ( : )
* Be sure to EXCLUDE the "TOTALS" and "AVERAGE" cells in the range.
Also, take the cell for Salary and do the following:
Salary/ Home Run =cell for Salary/cell for TOTAL HR
Salary/ Hits =cell for Salary/cell for TOTAL Hits
Salary/RBI =cell for Salary/cell for RBI
Make sure all numbers for Batting Average is only 3 decimal places.
No comments:
Post a Comment