Finding the Average of numbers generated using the IF function (1 Viewer)

[Tech_Girl]

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?

 

[Brianwarnock]

I don't really understand the question as you would average a range

=AVERAGE(a2:a10)

But I would also add that numbers should not be in"""

=If(F2>=15,4 etc

And I've just remembered that with them all being text you will get a Div/0 error

Brian

 

[Tech_Girl]

Brian,

Thank you soooo much....I am new to nested formulas, etc.....but once I took the "" off, it worked perfectly!!!! I could average, etc. once I formatted them as a number...I didn't get the error message...

Again, thank you for taking the time to help me....I work for a school system and this spreadsheet is going to be a lifesaver for 1200 teachers.

Have a wonderful day!