Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hi
"Marko Pinteric" wrote in message ... I have a cell with formula A1 = IF(condition,value,"") Since condition is not fulfilled, the cell "seems" to be empty. However another cell refers to this cell C1 = A1 * B1 and formula returns error #VALUE! If cell A1 would be REALLY empty, function in C1 would return simply 0. How to make cell A1 look REALLY empty to formula in C1? Deleting the cell entry (select cell and hit Del, or use some VBA equivalent of it) To bypass your problem, use the formula C1=IF(A1="",0,A1)*B1 -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets |
#2
|
|||
|
|||
Function making cell really "empty"
I have a cell with formula
A1 = IF(condition,value,"") Since condition is not fulfilled, the cell "seems" to be empty. However another cell refers to this cell C1 = A1 * B1 and formula returns error #VALUE! If cell A1 would be REALLY empty, function in C1 would return simply 0. How to make cell A1 look REALLY empty to formula in C1? Regards, Marko |
#3
|
|||
|
|||
Arvi Laanemets wrote...
.... To bypass your problem, use the formula C1=IF(A1="",0,A1)*B1 Simpler to use =N(A1)*B1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |