| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank cell with Formulas
I have a series of cells filld with formulas, but the value of the cells is
null. I then in some other cells used if function, which will evaluate the above cells, and if the value of the above is null then output something like "-", otherwise some real numbers. However, when the reference cell values are blank, excel continuously gives me error messages. I wonder if it's the formulas underlying those cells are screwing everything up. And if yes, is there a fix to this? thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blank cell with Formulas
Here is an example that will work. If B9 contains:
=IF(1=1,"","") it will always return a null. Therefore another cell that contains: =IF(B9="","-","") will always return a dash. It will return a dash even if B9 is completely empty. -- Gary''s Student - gsnu200782 "Lily" wrote: I have a series of cells filld with formulas, but the value of the cells is null. I then in some other cells used if function, which will evaluate the above cells, and if the value of the above is null then output something like "-", otherwise some real numbers. However, when the reference cell values are blank, excel continuously gives me error messages. I wonder if it's the formulas underlying those cells are screwing everything up. And if yes, is there a fix to this? thanks, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blank cell with Formulas
Here is my situation,
In cell A1, =if(b1=a+b, 1, ""), and A1 returned "". In cell c1, =if(a1="", "-", 1) what I got is #value! instead of "-". Any ideas? Lily "Gary''s Student" wrote: Here is an example that will work. If B9 contains: =IF(1=1,"","") it will always return a null. Therefore another cell that contains: =IF(B9="","-","") will always return a dash. It will return a dash even if B9 is completely empty. -- Gary''s Student - gsnu200782 "Lily" wrote: I have a series of cells filld with formulas, but the value of the cells is null. I then in some other cells used if function, which will evaluate the above cells, and if the value of the above is null then output something like "-", otherwise some real numbers. However, when the reference cell values are blank, excel continuously gives me error messages. I wonder if it's the formulas underlying those cells are screwing everything up. And if yes, is there a fix to this? thanks, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blank cell with Formulas
=IF(ISERROR(IF(B1=A+B, 1, "")),"",1)
-- Malik "Lily" wrote: Here is my situation, In cell A1, =if(b1=a+b, 1, ""), and A1 returned "". In cell c1, =if(a1="", "-", 1) what I got is #value! instead of "-". Any ideas? Lily "Gary''s Student" wrote: Here is an example that will work. If B9 contains: =IF(1=1,"","") it will always return a null. Therefore another cell that contains: =IF(B9="","-","") will always return a dash. It will return a dash even if B9 is completely empty. -- Gary''s Student - gsnu200782 "Lily" wrote: I have a series of cells filld with formulas, but the value of the cells is null. I then in some other cells used if function, which will evaluate the above cells, and if the value of the above is null then output something like "-", otherwise some real numbers. However, when the reference cell values are blank, excel continuously gives me error messages. I wonder if it's the formulas underlying those cells are screwing everything up. And if yes, is there a fix to this? thanks, |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blank cell with Formulas
ignore this please. It;s wrong
Instead: =IF(ISERROR(B1=a+b),"",IF(B1=a+b,1,"")) -- Malik "Malik" wrote: =IF(ISERROR(B1=A+B), 1, "")),"",1) -- Malik "Lily" wrote: Here is my situation, In cell A1, =if(b1=a+b, 1, ""), and A1 returned "". In cell c1, =if(a1="", "-", 1) what I got is #value! instead of "-". Any ideas? Lily "Gary''s Student" wrote: Here is an example that will work. If B9 contains: =IF(1=1,"","") it will always return a null. Therefore another cell that contains: =IF(B9="","-","") will always return a dash. It will return a dash even if B9 is completely empty. -- Gary''s Student - gsnu200782 "Lily" wrote: I have a series of cells filld with formulas, but the value of the cells is null. I then in some other cells used if function, which will evaluate the above cells, and if the value of the above is null then output something like "-", otherwise some real numbers. However, when the reference cell values are blank, excel continuously gives me error messages. I wonder if it's the formulas underlying those cells are screwing everything up. And if yes, is there a fix to this? thanks, |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blank cell with Formulas
=IF(ISNA(F19),"-",IF(ISERROR(F19),"-",F19))
-- Malik "Lily" wrote: I have a series of cells filld with formulas, but the value of the cells is null. I then in some other cells used if function, which will evaluate the above cells, and if the value of the above is null then output something like "-", otherwise some real numbers. However, when the reference cell values are blank, excel continuously gives me error messages. I wonder if it's the formulas underlying those cells are screwing everything up. And if yes, is there a fix to this? thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last cell in range of formulas not equal to blank | Excel Programming | |||
| Referencing cells with formulas results in blank cell. | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
| How to read a blank cell as zero for formulas? | Excel Discussion (Misc queries) | |||
Hybrid Mode
