View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default IF function help

=if(t2="","",if(t2<10, ....



cjborntorun wrote:

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!


--

Dave Peterson