Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Empty Cell ( blank Cell )
How to write formula or write in the formula " if cell is left blank or
empty" skip and carry with the rest of the formula |
#2
|
|||
|
|||
Would you give a little more detail? I am not sure what you want to do.
"rocky" wrote: How to write formula or write in the formula " if cell is left blank or empty" skip and carry with the rest of the formula |
#3
|
|||
|
|||
Maybe you're looking for something like this........
=IF(A1=B1,"",A1+B1) Which says in Excel formula language, "if cell A1 is equal to cell B1, then leave the cell where this formula is located blank, otherwise, put in it the sum of A1 and B1......... or maybe, =IF(A1="",B1*2, B1*3) Which says, if Cell A1 is empty, then put in the cell where this formula is the product of B1 times 2, otherwise put B1 times 3... The two quotation marks with no space between them represent the "null" condition or for display purposes, a blank or empty cell........... Vaya con Dios, Chuck, CABGx3 "rocky" wrote in message ... How to write formula or write in the formula " if cell is left blank or empty" skip and carry with the rest of the formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank cell turns to 0 | New Users to Excel | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel |