| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To leave a blank cell
Hello from Steved
With the below formula what is required please to have the cell blank as at the moment it shows 0. ps I do not want to turn zero off ='City Depot'!C9+'Panmure Depot'!C9 Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To leave a blank cell
something like:
=If(Yourformula=0,"",Yourformula) Note that there is NO space between the two quote marks. In other words, it is "", not " ". HTH Otto "Steved" wrote in message ... Hello from Steved With the below formula what is required please to have the cell blank as at the moment it shows 0. ps I do not want to turn zero off ='City Depot'!C9+'Panmure Depot'!C9 Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To leave a blank cell
Hi Steved,
How about Tools/options/view, and deselect "zero values" ? "Steved" wrote: Hello from Steved With the below formula what is required please to have the cell blank as at the moment it shows 0. ps I do not want to turn zero off ='City Depot'!C9+'Panmure Depot'!C9 Thankyou. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To leave a blank cell
Do you mean ...?
=IF('City Depot'!C9+'Panmure Depot'!C9=0,"",'City Depot'!C9+'Panmure Depot'!C9) HTH "Steved" wrote: Hello from Steved With the below formula what is required please to have the cell blank as at the moment it shows 0. ps I do not want to turn zero off ='City Depot'!C9+'Panmure Depot'!C9 Thankyou. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To leave a blank cell
Have you tried conditional formatting? (Menu: Format - Conditional Formatting) Set up the cell so that values less than zero have white type. Jill -- jillteresa ------------------------------------------------------------------------ jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498 View this thread: http://www.excelforum.com/showthread...hreadid=562199 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To leave a blank cell
I thankyou all
"Steved" wrote: Hello from Steved With the below formula what is required please to have the cell blank as at the moment it shows 0. ps I do not want to turn zero off ='City Depot'!C9+'Panmure Depot'!C9 Thankyou. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To leave a blank cell
You could also give the cell's number format a custom format like:
#;-#; (replace the # and -# with your desired format for positive and negative numbers) HTH, Ryan "Steved" wrote: Hello from Steved With the below formula what is required please to have the cell blank as at the moment it shows 0. ps I do not want to turn zero off ='City Depot'!C9+'Panmure Depot'!C9 Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum in first blank cell and a few more things... | Excel Discussion (Misc queries) | |||
| Return of blank cell if lookup fails | Excel Worksheet Functions | |||
| To Leave Cell blank Please | Excel Worksheet Functions | |||
| blank cell turns to 0 | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
