View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I write an "if" formula??? See below......

Maybe

=IF(U10="F","",U10)

or

=IF(U10="F",U10,"")

Mike

"Danno" wrote:

if(U10="F")leave this cell (where the formula is) blank?? Not enter a
zero.....just leave that cell empty. All help will be greatly appreciated.
Thanks!