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...

excel

m_tarler
Nov 12, 2025
Yes you can use NOT() in that statement. I think you want:
=IF(AND(NOT(OR($C327="Saturday",$C327="Sunday")),(ISBLANK(X327))),X$6,0)
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)

m_tarler

Bronze Contributor

Nov 12, 2025

Yes you can use NOT() in that statement. I think you want:

=IF(AND(NOT(OR($C327="Saturday",$C327="Sunday")),(ISBLANK(X327))),X$6,0)

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)

mbanks

Copper Contributor

Nov 13, 2025

Thanks all...

=IF(AND(NOT(OR($C327="Saturday",$C327="Sunday")),(ISBLANK(X327))),0,X$6)

This worked a treat :-)

Forum Discussion

IF ISBLANK and NOT

Resources