Forum Discussion

mbanks's avatar
mbanks
Copper Contributor
Nov 12, 2025
Solved

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's avatar
    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)

     

mathetes's avatar
mathetes
Gold Contributor
Nov 13, 2025

m_tarler​ Unless I'm mistaken, your final =IF(OR(.... is the logical flip side of my =IF(AND(....

Once again illustrating that in Excel there are always multiple ways to get from point A to point B.😀

m_tarler's avatar
m_tarler
Bronze Contributor
Nov 13, 2025

I changed them all based on the following:

I am realizing why I am having so much trouble with this problem.  The OP says:

The value in column AM for each row is calculated with a formula, so it will give the value of X6 if X in the same row is empty, or 0 if X in the same row has a value.

so ISBLANK() => X6 and NOT(ISBLANK() ) => 0, which is confirmed on the next line:

=IF(ISBLANK(X324),X$6,0) will give me what I want

BUT then OP says:

mbanks wrote:

=IF(AND(OR($C327="Saturday",$C327="Sunday"),(ISBLANK(X327))),0,X$6) will give me 0 if X327 is Blank and C327 is either Saturday OR Sunday

which seems to indicate they want the output 0 if C327 is blank, which is the opposite of above.  But ultimately I think we need to go with this statement:

mbanks wrote:

if X327 is Blank and C327 is not either Saturday or Sunday then it will return value X6

which I believe can also be stated as:

IF X327 is NOT BLANK or C327 is the WEEKEND then 0

I have corrected my original statement based on this final statement.

Resources