Formula help

J

jbphoenix

C139 is a drop down with the numbers 0-4. The user chooses a number and
then either a 1 or 0 is placed in the correct column. At the end of the
sheet there is a count of how many 1's, 2's and so on. There are 5 columns
(0-4) and a 1 is entered in the correct column depending on what is in C139.

Here is a copy of my formula - =IF(C139=0,1,0). Pretty straight forward but
the results aren't what I expect. If I delete what is in that cell C139 I
get a 1 in the 0 column. I want to be a 0 since there is nothing in the
field.
 
J

jbphoenix

I tried this formula =IF((OR(C139=0,C139="")),1,0)

But I'm still getting a 1 instead of a 0. If C139 is blank I want a 0
instead of a 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing letters from cells 2
using SUMIF with ISNUMBER 6
Mail Merge Switch - Dollars to Words 0
VBA Coding Help for Beginner 0
Countdown macro - display settings 2
Mail Merge Help 1
Cumulative formula for word table 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top