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?
=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?