Using nested If function

[tara_922]

Hiya All!

You have all been incredibly amazing so far. I have another question. I know this is possible, it's just not working the way I think it should. So obviously there's a problem with the way I'm thinking it should work. Any and all assistance is appreciated!

So far this is my formula,
=IF(ISERROR(AVERAGE(B17:L17)),"",AVERAGE(B17:L17))

This is working great, however, I want to add a condition that IF the Average of B17:L17=<.01 then it returns the value "<1%"

Thanks again in advance!

Tara

 

[RichardMGreen]

Try:-
=IF(ISERROR(AVERAGE(B17:L17),"",if(AVERAGE(B17:L17)<=0.01,"<1%",AVERAGE(B17:L17)))

 

[tara_922]

Hiya RichardMGreen!

You are amazing! Thanks so much for the formula! It's working wonders! I'm so excited to have found some good support!

Tara

 

[tara_922]

Hiya all!

Can I ask one more question please?

So, the formula is returning <1%, which is great, however, if the value is 0% I want a 0% returned. So I guess, what I need is if the value is >0 and <1 I want ,1% returned. Any luck??

Thanks,
Tara

 

[RichardMGreen]

Try this:-
=IF(ISERROR(AVERAGE(B17:L17),"",if(AVERAGE(B17:L17)=0,"0%",if(AVERAGE(B17:L17)<=0.01,"1%",AVERAGE(B17:L17))))

I think that's the right number of brackets.

 

[tara_922]

Absolutely perfect! You're amazing! Thanks again!

Tara