Solved

What formula would I use in excel to do the task described in the body of this post?

Posted on 2015-01-20
4
76 Views
Last Modified: 2015-01-20
I have an excel spread sheet with a column  that contains  numbers in some cells and nothing in other cells.
I need an equation where I can transform the cells that contain numbers to  1 and cells that are blank to 0.
Thanks
0
Comment
Question by:PDSWSS
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
mankowitz earned 500 total points
ID: 40560872
you should be able to use ISBLANK

The equation would look like

IF(ISBLANK(a1), 0, 1)
0
 
LVL 7

Expert Comment

by:slubek
ID: 40560877
Try
=If(ISBLANK(A1);0;1)

Open in new window

Edit: I see mankowitz was first, and I misused ';' instad of ','.
0
 
LVL 24

Expert Comment

by:mankowitz
ID: 40560882
@slubek-  one of the things I don't understand about OO is why they use semicolons.
0
 

Author Closing Comment

by:PDSWSS
ID: 40560977
Perfect answer. Thank you very much.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now