Thread: How to make IF function not change cell value?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SE SE is offline
external usenet poster
  
Posts: 1
Default How to make IF function not change cell value?
How do I make a IF function do this? IF(CELL1 = X ,CELL1,CELL2) The formula
is located in CELL2. When the IF function is false, then I want the value in
CELL2 to stay the same. I get a circular reference with this format.
Reply With QuoteReply With Quote