Help on a Simple Formula Please

**seraphim666** · 08-27-2013, 06:13 AM

Good day to you all,

I'm going to be embarrassed here as I can't for the life of me figure something that appears to be so simple out, here goes,

I have two cells, A1 and B1 that are blank, in cell C1 I have a formula =IF(A1=B1,1,0). The idea is to type numbers in A1 and B1 and if the are equal the value 1 appears in C1 and if not the value 0 will appear.

However, with both A1 and B1 empty and as soon as I type the formula above into C1 and hit enter, I get the value 1.

Can somebody, point me in the right direction please.

Yours, an embarrassed,
seraphim666

**VKS** · 08-27-2013, 06:22 AM

Hello Seraphim,
Try this:

Formula:

Please Login or Register  to view this content.

Best Regards/VKS

**Fotis1991** · 08-27-2013, 06:29 AM

Hi

As you have not many posts here probably you haven't read the forum rules and specially rule 1 which describe how to use a correct title for your thread. Pls amend your title to something that describe your problem. Something like "Adding 1 more condition to an IF function" and then we'll be happy to offer a solution to your problem.

**seraphim666** · 08-27-2013, 06:35 AM

Hi VKS,

Thank you for your prompt response. When I type the formula in and with cells A1 and B1 empty, it returns a blank cell that's great. However, when I input numbers lets say to A1 has 4 and B1 has 4, cell C1 returns 8.

What I would like is for cell C1 to return a value of 1 as A1 and B1 are equal.

Hope that makes sense. Sorry to be a pain.

Regards,
seraphim666

**VKS** · 08-27-2013, 06:37 AM

Hello Seraphim, Please ref. post no. 3

**arlu1201** · 08-27-2013, 07:22 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Also,

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.