I have a nested formula in my excel file....
=IF(F2>=15%,"4",IF(F2>=10%,"3",IF(F2>=5%,"2","1")))
Now I want to average the numbers that were generated from this formula (4, 3, 2, and 1)....I am unable to do this.....Can this be done?
I am trying to design a database that will allow me to keep up with all of the teachers in our school district and their administrative computer and printer. It has taken me nearly a year to collect all of this data into 36 separate excel spreadsheets and now I want to compile all of it into an...