Thread: excel question borderline programing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
MartinW
 
Posts: n/a
Default excel question borderline programing
Hi Duane,

Put =IF(B1="x","*","") in cell A1 if you want it to return blank
or =IF(B1="x","*",0) if you want it to return 0

HTH
Martin


Reply With QuoteReply With Quote