| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula returning a blank cell
In cell c1 I have the formula =IF(A10,B1)
In cell B1 I have the words "count costs" I want cell C1 to return the words "count costs" when A1 is greater than 0 (that works fine). But if the volue in A1 = zero I want C1 to return a blank cell. TIA for any help -- bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula returning a blank cell
Just need to enter an ELSE
=IF(A10,B1,"") "vdmbqb" wrote: In cell c1 I have the formula =IF(A10,B1) In cell B1 I have the words "count costs" I want cell C1 to return the words "count costs" when A1 is greater than 0 (that works fine). But if the volue in A1 = zero I want C1 to return a blank cell. TIA for any help -- bob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula returning a blank cell
=IF(A10,B1,"")
It won't be blank, just look blank. Gord Dibben MS Excel MVP On Thu, 24 Sep 2009 13:39:01 -0700, vdmbqb wrote: In cell c1 I have the formula =IF(A10,B1) In cell B1 I have the words "count costs" I want cell C1 to return the words "count costs" when A1 is greater than 0 (that works fine). But if the volue in A1 = zero I want C1 to return a blank cell. TIA for any help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula returning a blank cell
This is my exact problem need a blank cell as i will be using the data in
access . Anton "Gord Dibben" wrote: =IF(A10,B1,"") It won't be blank, just look blank. Gord Dibben MS Excel MVP On Thu, 24 Sep 2009 13:39:01 -0700, vdmbqb wrote: In cell c1 I have the formula =IF(A10,B1) In cell B1 I have the words "count costs" I want cell C1 to return the words "count costs" when A1 is greater than 0 (that works fine). But if the volue in A1 = zero I want C1 to return a blank cell. TIA for any help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula returning a blank cell
No formula can return a truly blank cell.
Gord On Fri, 27 Nov 2009 07:56:05 -0800, Anton wrote: This is my exact problem need a blank cell as i will be using the data in access . Anton "Gord Dibben" wrote: =IF(A10,B1,"") It won't be blank, just look blank. Gord Dibben MS Excel MVP On Thu, 24 Sep 2009 13:39:01 -0700, vdmbqb wrote: In cell c1 I have the formula =IF(A10,B1) In cell B1 I have the words "count costs" I want cell C1 to return the words "count costs" when A1 is greater than 0 (that works fine). But if the volue in A1 = zero I want C1 to return a blank cell. TIA for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying non-returning formula (blank Cell) | Excel Worksheet Functions | |||
| Formula returning a blank cell if answer is zero | Excel Discussion (Misc queries) | |||
| returning blank when reference cell is blank | Excel Worksheet Functions | |||
| returning blank cell | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
Hybrid Mode
