IF in combination with larger than

[Guest]

Hi,

cell C1 contains:

=IF(A1>3,1,0)

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

Thanks!

tom

 

[Ardus Petus]

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

Cheers,

 

[Pete_UK]

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

 

[Guest]

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

 

[Bob Phillips]

Obviously?

--
HTH

Bob Phillips

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