Forum Discussion
IF ISBLANK and NOT
Hi all, I am banging my head against a brick wall trying to figure this out. Column C has a day in it. Cell X6 has a value in it which automatically updates every day. Column X has new values ent...
Yes you can use NOT() in that statement. I think you want:
=IF(AND(NOT(OR($C327="Saturday",$C327="Sunday")),(ISBLANK(X327))),0,X$6)Alternatively I think the following should also work:
=IF(OR($C327="Saturday",$C327="Sunday",NOT(ISBLANK(X327))),0,X$6)and finally there is a difference between ISBLANK() and ="" but if in this case either works you could use
=IF(OR($C327="Saturday",$C327="Sunday",X327<>""),0,X$6)wait I take that all back, what I think you want is just an OR statement
=IF(OR($C327="Saturday",$C327="Sunday",ISBLANK(X327)),0,X$6)