View Single Post
  #1   Report Post  
Mindie
 
Posts: n/a
Default Adding another field if the equation = True

If this equation is equal to True, How to I tell it to also add a cell from
another sheet. If this is equal to true I want it to read for example Nov 22
2004 PT
=IF(B21=TRUE, TEXT(C20,"mmm dd yyyy"), TEXT(E20, "mmm yyyy"))