Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
I have the following formula: =SUM(C9-E9-F9)
This formula is then dragged down for many rows and works perfectly except for one thing, in the rows that have no data in them, the cell shows up as £0.00. Is it possible to have it that the cell remains blank until data is entered in the row? I hope this makes sense to you, Thank You for any replies. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
format the cells as Custom # ##0;-# ##0;
On 1 Cze, 10:51, "Fergal" wrote: I have the following formula: =SUM(C9-E9-F9) This formula is then dragged down for many rows and works perfectly except for one thing, in the rows that have no data in them, the cell shows up as £0.00. Is it possible to have it that the cell remains blank until data is entered in the row? I hope this makes sense to you, Thank You for any replies. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
Hi,
1 way. Note you don't need SUM =IF(COUNT(C9,E9,F9)=3,C9-E9-F9,"") Mike "Fergal" wrote: I have the following formula: =SUM(C9-E9-F9) This formula is then dragged down for many rows and works perfectly except for one thing, in the rows that have no data in them, the cell shows up as £0.00. Is it possible to have it that the cell remains blank until data is entered in the row? I hope this makes sense to you, Thank You for any replies. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|