View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cjborntorun cjborntorun is offline
external usenet poster
 
Posts: 6
Default IF function help

Hi - I currently have this formula:

=IF(T2<10,Y, )


Problem is, if cell T2 is blank/null, I still get a Y, but I dont want
one. How can I enhance this formula so that it ignores null value in T2?

Thank you in advance for your help!