| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if no data in cell show as blank
Iv got the following formula in cell H803:
=SUM(F803:F808)+H799 Is there a way that if there is no data in any of these cells (F803:F808). Cell H803 remains blank. -- George |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if no data in cell show as blank
if a1:c1 is the range of interest, try in d1:
=IF(SUMPRODUCT(--(A1:C1="")),"","x") "George" wrote: Iv got the following formula in cell H803: =SUM(F803:F808)+H799 Is there a way that if there is no data in any of these cells (F803:F808). Cell H803 remains blank. -- George |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if no data in cell show as blank
Didn`t work. The cell remains blank when data is inserted in any of the cells
F803:F808. -- George "Evan" wrote: if a1:c1 is the range of interest, try in d1: =IF(SUMPRODUCT(--(A1:C1="")),"","x") "George" wrote: Iv got the following formula in cell H803: =SUM(F803:F808)+H799 Is there a way that if there is no data in any of these cells (F803:F808). Cell H803 remains blank. -- George |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if no data in cell show as blank
sorry - pls try
=IF(SUMPRODUCT(--(F803:F808<"")),"x","") Aside from change of range, the test was backwards "George" wrote: Didn`t work. The cell remains blank when data is inserted in any of the cells F803:F808. -- George "Evan" wrote: if a1:c1 is the range of interest, try in d1: =IF(SUMPRODUCT(--(A1:C1="")),"","x") "George" wrote: Iv got the following formula in cell H803: =SUM(F803:F808)+H799 Is there a way that if there is no data in any of these cells (F803:F808). Cell H803 remains blank. -- George |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if no data in cell show as blank
Thanks very much, another obtion I can use. Very useful.
-- George "Evan" wrote: sorry - pls try =IF(SUMPRODUCT(--(F803:F808<"")),"x","") Aside from change of range, the test was backwards "George" wrote: Didn`t work. The cell remains blank when data is inserted in any of the cells F803:F808. -- George "Evan" wrote: if a1:c1 is the range of interest, try in d1: =IF(SUMPRODUCT(--(A1:C1="")),"","x") "George" wrote: Iv got the following formula in cell H803: =SUM(F803:F808)+H799 Is there a way that if there is no data in any of these cells (F803:F808). Cell H803 remains blank. -- George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a cell show relevant data | Excel Discussion (Misc queries) | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
