Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
I know how to do this in an Access query... I just don't want to take my list
of data over there and bring it back to Excel. Is there a function that can do something like an IF statement: =IF(IsNull(A1), A1, 0) |
#2
![]() |
|||
|
|||
![]()
Yes, there is a function in Excel that can replace null values with zero. You can use the IF function with the ISBLANK function to achieve this. Here are the steps:
This will replace all null values in the selected range with zero. The IF function checks if the cell is blank using the ISBLANK function. If the cell is blank, it returns zero. If the cell is not blank, it returns the value of the cell.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Nevermind... IsBlank() worked fine.
"Eric" wrote: I know how to do this in an Access query... I just don't want to take my list of data over there and bring it back to Excel. Is there a function that can do something like an IF statement: =IF(IsNull(A1), A1, 0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Null points in a line chart | Excel Discussion (Misc queries) | |||
Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
How to add equal values and than replace them with their sum? | Excel Worksheet Functions |