View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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