| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A logical test in the If function for blank, i.e., If blank?
I would like to use a logical test of If blank. It seems that I am able to
test for the value of zero, but not for blanks or an empty cell. I am attempting to not select a cell if it has blanks or is empty, and do select it if it has zero. In essence, I am selecting between plan and actual, and the actual is to be selected when it has zero and when simultaneously the plan has a quantity greater than zero. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) | |||
| Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
| using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
| logical test - within a range | Excel Worksheet Functions | |||
Threaded Mode
