Multiple Average Conditions with #DIV/O! errors. How to get rid of them?

[DCAbound]

Can anyone suggest a fix to my function. Combination average functions and hot to get rid of the #DIV/O! error. This is what I have so far and still does't work.

=IF(AVERAGE(DB9:DD9)>3.25,"Advance",IF(AVERAGE(DB9:DD9)>2.5,"Established",IF(AVERAGE(DB9:DD9)>1.75,"Emerging",IFERROR(AVERAGE(DB9:DD9),"Latent"))))

 

[Part Time user]

Here's one possiblility: The trick is to check for an error first.

=IF(ISERROR(AVERAGE(DB9:DD9)),"Latent",IF(AVERAGE(DB9:DD9)>3.25,"Advance",IF(AVERAGE(DB9:DD9)>2.5,"Established",IF(AVERAGE(DB9:DD9)>1.75,"Emerging","Some Statement for small Average"))))

 

[DCAbound]

Thanks so much! That worked!

 

[DCAbound]

Actually didn't work. Made everything "Latent" Any other advice please?

 

[Part Time user]

Is the cell format in DB9:DD9 set to 'text'?

 

[Aladin Akyurek]

Actually didn't work. Made everything "Latent" Any other advice please?

What must be the result if the average is 1.6?

 

[DCAbound]

What must be the result if the average is 1.6?

Emerging. All else latent

 

[DCAbound]

No it's numbers. It's for a questionnaire. Decision rules answers.

 

[Aladin Akyurek]

Emerging. All else latent

Are you sure? Your own formula says: > 1.75 --> Emerging. 1.6 is smaller than 1.75! And when we have exactly 3.25, what do you want to see?

 

[DCAbound]

3.25>= advance
2.25>= established
1.25>= emerging
all else latent

appreciate your help!!