Thread: IF formula's
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default IF formula's

How about
IF(A2<"",Your number,0)

The English translation is "if A2 is not blank, enter my number; if it
is blank, enter zero."