I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.

What do you mean "the formula does not calculate"? Do you get an error?
Based on your formula, the result should be 0.

What do you get, and what do you expect, if not zero?



In article ,
Frances C wrote:

I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.

Perhaps this may suffice:
=IF(H16="","",H16*N16*IF(R160,R16,1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frances C" wrote:
I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.

it does not work, it gives me a false

"Max" wrote:

Perhaps this may suffice:
=IF(H16="","",H16*N16*IF(R160,R16,1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Frances C" wrote:
I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.

The formula works fine, It calculates very good. and It does not show up if I
do not enter a number in the H16 cell. and that is the way I wanted it.

But the new problem that I have is that If I want to enter a 0 zero in cell
H16 the formula does not reconize 0 it does not show up a 0 as a result.

For example =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")

H16=20 and N16 = 1 result is 20, but if I have to enter H16=0 and N16=0 the
formula does not calculate the result 0

Note I understand that "" makes the formula (invisible) not to show if is
not necesary. I need this formula to reconize the 0 and to show up only when
requested

"JE McGimpsey" wrote:

What do you mean "the formula does not calculate"? Do you get an error?
Based on your formula, the result should be 0.

What do you get, and what do you expect, if not zero?



In article ,
Frances C wrote:

I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.

On Wed, 31 Oct 2007 08:26:00 -0700, Frances C
wrote:

I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.


Your formula seems to work OK here.

How are you entering the zero into H16?

How are entering other values into H16?

When you put a zero into H16, what is the contents of N16?
--ron

"Frances C" wrote
it does not work, it gives me a false

Perhaps this may suffice:
=IF(H16="","",H16*N16*IF(R160,R16,1))

I don't know how the suggested alternative could have possibly returned
FALSE over there.

It either returns zero if you input a zero in H16 where N16/R16 is either
blank or contain numbers.

Or it returns an error: #VALUE! if N16 or R16 contains text instead of
number(s).

If H16 is blank, it'll simply return a blank: ""
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---