IF in combination with larger than
 

Hi,

cell C1 contains:

=IF(A13,1,0)

this obviously does not work, but how to achieve this?

Thanks!

tom

IF in combination with larger than
 

You get a result of 1 or 0
Which result did you expect?

Cheers,
--
AP

"tom ossieur" a écrit dans le message
de news: ...
Hi,

cell C1 contains:

=IF(A13,1,0)

this obviously does not work, but how to achieve this?

Thanks!

tom

IF in combination with larger than
 

I don't know what you mean by " ... this obviously does not work ..."

Check that A1 is not formatted as text. If it is a number that is
greater than 3 then cell C1 should return 1, otherwise 0. Is this what
you want?

Pete

tom ossieur wrote:
Hi,

cell C1 contains:

=IF(A13,1,0)

this obviously does not work, but how to achieve this?

Thanks!

tom

IF in combination with larger than
 

hmmm... undoubtly the most stupid question i've ever posted... sorry and
thanks... seems i did something wrong...

"Ardus Petus" wrote:

You get a result of 1 or 0
Which result did you expect?

Cheers,
--
AP

"tom ossieur" a écrit dans le message
de news: ...
Hi,

cell C1 contains:

=IF(A13,1,0)

this obviously does not work, but how to achieve this?

Thanks!

tom

IF in combination with larger than
 

Obviously?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tom ossieur" wrote in message
...
Hi,

cell C1 contains:

=IF(A13,1,0)

this obviously does not work, but how to achieve this?

Thanks!

tom