Thread: How do I clear contents in my workbook w/o loosing my formulas?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do I clear contents in my workbook w/o loosing my formulas?
=IF(OR(A2:A5000={200000,300000,400000}),"YES","NO" )

ctrl+shift+enter, not just enter


"Julie E" wrote:

I have saved my wookbook, using save as from another file.
Reply With QuoteReply With Quote