Star Gazr1
asked on
Excel return blank cell as 0
I am working with Excel 2010. I attached a sample spreadsheet. I am looking to return the values in column A on sheet2 to column A in sheet1.
I would like the 0 values and blank cells to return as value 0. I tried to work with =ISBLANK but wasn't working. Any info is greatly appreciated, thank you.
Book1.xlsx
I would like the 0 values and blank cells to return as value 0. I tried to work with =ISBLANK but wasn't working. Any info is greatly appreciated, thank you.
Book1.xlsx
ASKER
thanks for the reply. I am not sure I was clear in my question, so I will try to clarify. In Sheet1 I am looking for a formula in Cell A2, that will bring back the value in cell A2 in Sheet2. If the value is blank I want it to display 0, if the Value is 0, I also want it to display 0. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks that works, I appreciate it.
=IF(A1="","",A1)
When referencing ranges of cells use a multiple cell array formula:
=IF($A$1:$Z$100="","",$A$1
Multiple cell array formulas are entered by selecting the destination cells, entering the formula in the first cell, and pressing CTRL+SHIFT+ENTER.
Kevin