If forumula Question

[lilsnoop]

If I want to assign a "zero" or 0 value to a blank or rather empty cell, but other values if certain variable data is placed in this same cell, how can I construct my formula? I've attempted the following with negative results... any help would be greatly appreciated!

=ISBLANK(E22,0,IF(E22<=$E$31,1,IF(E22<=$E$30,2,IF(E22<=$E$29,3,IF(E22<$E$28,3,IF(E22>=$E$27,5,IF(E22<$E$27,4)))))))

[davesexcel]

does if(isblank(
work??

or how about
=if(e22="",0,if(

[lilsnoop]

Thanks for the help!!!