Unable to calculate average of values returned from IF function

[Slumsu]

Hi,

I'm having trouble with the average formula in my excel sheet. I'm simply wanting to calculate the average of three cells, however the average function is returning a #Div/0! error as if the cells are empty. I should mention that the values in the cells I'm trying to average are returned via an 'IF' function - I think that this is probably causing the issue. Is there any way to get round this problem?

Further info
My IF formula is: =IF(AN7="Easily","1",IF(AN7="After some time","2",IF(AN7="With difficulty","3")))
I'm using these formulas to code responses for qualitative data I've collected so I can run stats on it.

Cheers!

 

[Toadstool]

Hi Slumsu,

Try removing the quotes from around the "1","2","3" so it treats them as numeric 1,2,3

 

[Slumsu]

Oh, that's worked perfectly! Thank you so much .