Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am uploading values from an existing data base. Sometimes there is no items
sold during the time so it just gives me a blank area. I need to change that to a zero so it will calculate correctly. I have tried @if statements but am getting no results sinve the area is blank to begin with. All i need is a statement that says if the area is blank result =0, or the number that is there. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expression for Blank Spaces | Charts and Charting in Excel | |||
ranking with some blank spaces | Excel Worksheet Functions | |||
Blank Spaces on Sort | Excel Discussion (Misc queries) | |||
Blank spaces | Excel Discussion (Misc queries) | |||
Blank spaces in a listbox | Excel Discussion (Misc queries) |