Ignoring blank cells in a formula

[ftzamar]

This is the formula I am using in my spreadsheet. The column the formula is looking at does include zeros as a value, but the formula as written includes the blank cells as a zero, which it should not. I need to exclude those.

Here is the formula:

=IF(AND(I3>=0,I3<=5),"<=5%",IF(AND(I3>=6,I3<=10),"6-10%",IF(AND(I3>=11,I3<=25),"11-25%",IF(AND(I3>=26,I3<=50),"26-50%",IF(AND(I3>=51,I3<=75),"51-75%",IF(I3>75,">75",""))))))

How do I add to this to exclude the blank cells

Thanks.

 

[Special-K99]

You've left out the percentage in the ">75" result.

You can replace your somewhat lengthy formula with this

=LOOKUP(I3,{0,6,11,26,51,75},{"<=5%","6-10%","11-25%","26-50%","51-75%",">75%"})

and if you want to exclude blank cells

=IF(I3="","",LOOKUP(I3,{0,6,11,26,51,75},{"<=5%","6-10%","11-25%","26-50%","51-75%",">75%"}))

 

[Joe4]

Welcome to the Board!

You can exclude blank cells by using the LEN function, i.e.

LEN(I3)>0

or by checking for the empty string, i.e.

I3<>""

Place in your formula where desired.