Copying Formula from one spreadsheet to another

[sm2200]

How do you copy a formula, specifically an =IF statement, from one spreadsheet to another ?

Thanks,


Sam Marx




Disregard "ACN" question that follows

 

[Festus Hagen]

Select the cell, hit F2, highlight the formula, copy, switch to the new sheet, select the cell and paste.

If you want to do ranges, select the range, Find and Replace the "=" with a "#" sign, then copy and paste to the new workbook, in the new workbook select the range, find and replace the "#" with an "=" ...

-Enjoy
fh <font color="#FF0000">:</font> )_~