Similiar to Blank Formula Fields

notion54

New Member
Joined
Mar 16, 2002
Messages
2
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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.
 
Upvote 0
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:
<snipped>

=ISNUMBER(J12)*(ISNUMBER(K12)*(J12=K12)

will do what you want.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top