Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need help using formulas in Excel
I made a spreadsheet for my Budget and I need a assistance. I want to be able
to clear the dollar amounts in the cells without clearing the way the cell is formated and clearing the formula.... For example, the cell contains $250, is formated so the dollar amount is in the middle and is underline, and it also contains a formula. I want to be able to remove the $250 w/o clearing the cell formula & format. |
#2
|
|||
|
|||
The formula is what returned the value.
So you'd have to remove the formula to remove the value. or change the formula... =if(a1="something","",yourformulahere) You add a check to see if the original formula should be evaluated--or just show what looks like an empty cell (""). Kent State Grad wrote: I made a spreadsheet for my Budget and I need a assistance. I want to be able to clear the dollar amounts in the cells without clearing the way the cell is formated and clearing the formula.... For example, the cell contains $250, is formated so the dollar amount is in the middle and is underline, and it also contains a formula. I want to be able to remove the $250 w/o clearing the cell formula & format. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |