I have a somewhat similiar problem.
I have this formula in N12 =IF(J12=K12,1,0)
If J12 and K12 are equal AND have numbers in them, all is fine. But if J12 and K12 are blank, it still returns the value 1.
What I want is, if J12 and K12 are blank ... to return the value 0 ... or ... nothing.
Would appreciate the help.
Excel Newbie
I have this formula in N12 =IF(J12=K12,1,0)
If J12 and K12 are equal AND have numbers in them, all is fine. But if J12 and K12 are blank, it still returns the value 1.
What I want is, if J12 and K12 are blank ... to return the value 0 ... or ... nothing.
Would appreciate the help.
Excel Newbie