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

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

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

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

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