Calculate IF AND formula only is cell is not blank

[4lauriet]

Hi all!

I am trying to return one number if an cell is greater than an amount and another if it is less than and generate nothing if the cell is blank.

I have tried several manipulations of this and I just cant seem to get it right.

Here are the stats

If E2 is blank return " "
If E2 <=9000, return 200
If E2 >9000, return 100

This is what I tried last to no avail:

=IF(isblank(e2)," ",IF(AND((E2>0,E2<=9000),200,100)))

 

[csenor]

Try this:

=IF(ISBLANK(e2),"",IF(e2<=9000,200,100))

 

[4lauriet]

Still returning 100 if cell is blank. I think I realize what the problem is (maybe). I just now realized I'm in google sheets. I have been digging so hard thinking I was in excel. (I didn't have enough coffee this morning maybe??)