I have several large spreadsheeets of data, and nearly all of the cells in the spreadsheet have some sort of formula in them. I need to clear what is in the cells, but at the same time keep the formula in so i dont have to input all the formulas again in each cell.
Is this possible? Your help is much appreciated!!!
Thanks!!!!
What kind of formula is it? You can't clear a formula, but you can clear references to the formula.
example:
Using the as a formula
=a1*.25
Clear a1 and you will probable get a 0 for a result
so this will show as blank if A1 is blank.
=if(a1="","",a1*.25)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks