IF in combination with larger than

T

tom ossieur

Hi,

cell C1 contains:

=IF(A1>3,1,0)

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

Thanks!

tom
 
P

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
 
T

tom ossieur

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

Bob Phillips

Obviously?

--
HTH

Bob Phillips

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