Thread: Resubmitting a question from yesterday...formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Casey[_14_] Casey[_14_] is offline
external usenet poster
  
Posts: 1
Default Resubmitting a question from yesterday...formula
Peter,
Try
=IF(C1=0,"all stores",IF(AND(C1<0,C16),"",C1))

Hope this helps

Case

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote