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
|