| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making formula results not visible in a cell
In my "total" column I don't want the results of the SUM to show up if there
is not an entry in the cell to the left of the SUM cell. -- MPS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making formula results not visible in a cell
=IF(A101="","",SUM(B1:B100))
-- David Biddulph "mp smith" wrote in message ... In my "total" column I don't want the results of the SUM to show up if there is not an entry in the cell to the left of the SUM cell. -- MPS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making formula results not visible in a cell
Try something like this:
=IF(A10="","",SUM(.....)) -- Biff Microsoft Excel MVP "mp smith" wrote in message ... In my "total" column I don't want the results of the SUM to show up if there is not an entry in the cell to the left of the SUM cell. -- MPS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making selected cells more visible | Excel Discussion (Misc queries) | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| Making visible a picture | Excel Discussion (Misc queries) | |||
| Making a form visible | Excel Discussion (Misc queries) | |||
| making only specified columns visible | Excel Discussion (Misc queries) | |||
Linear Mode
