IF Statement with ISBLANK function?

Good Evening,

I'm having some trouble getting my formula to do what I want it to do. I would like it to do the following:

If C29 is "0" or "1", then return "25". If not, return "0".in cell C30

My formula works great:

=IF(AND(C29=0,C29<=1),25,IF(AND(C29>1),0))

However, it is returning "25" when the C29 is left blank (which I do not want). I only want C30 to return a "25" if the value entered in C29 equals 1 or 0...any other value should return a "0"

Is there an easy way to do this? I tried an ISBLANK, but I think my parentheses got messed up.

Any help that you all could offer would be greatly appreciated!

-Peace

Based on the content of your question, the second IF() shouldn't be there at all. This formula will give 25 if C29 is 0, any value between 0 and 1 and is not blank, else it will display 0.

=IF(AND(C29=0, C29<=1, NOT(ISBLANK(C29))), 25, 0)

=if(and(or(c29=0,c29=1),len(c29)=1),25,0)

Or, for the really obtuse:

=25*OR(C29={0,1})*LEN(C29)

but I grant you - not very practical ;-)

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

To obtain your desired results, this will be your simplest way:

Place this formula in cell C30

Please Login or Register  to view this content.

In the original post, the poster had used AND. This would have required that the cell be both = 1 and = 0. The poster wanted the result of "If C29 is "0" or "1", then return "25". If not, return "0".in cell C30"

well 2 years or so they might