Thanks:  0
Likes:  0

# Thread: Similiar to Blank Formula Fields

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

2. On 2002-03-17 16:15, notion54 wrote:
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
=ISNUMBER(J12)*(ISNUMBER(K12)*(J12=K12)

will do what you want.

3. Wow ... I am impressed ... tried to figure that out for 3 hours. 3 minutes here did the trick ... that worked perfectly.

Thankyou

On 2002-03-17 16:19, Aladin Akyurek wrote:
=ISNUMBER(J12)*(ISNUMBER(K12)*(J12=K12)

will do what you want.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•