text: how can i use the "if" formulas so it can copy in other cell or worksheets? ie: if a column or row has text/information that will be used in another worksheet or cell. how do i set it up to save time and make sure is the same information. just make your if statement with an absolute reference to the data.  for example, instead of =if(d7=23,"good","bad") write =if($d$7=23,"good","bad").  when you copy the formula, it will automatically reference the d7 location.