| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Utilizing a Cell even with a Formula located inside it
Hi, I'm completely new to this board and was wondering if I could
possibly get some help. I'm trying to utilize a cell in which has a formula in it, however everytime I insert a value to utilize the formula, it of course.., gets cleared out. Is there anyway to maintain the formula inside the cell, then be able to just type a basic number into the cell and have the formula calculate. The formula I have now is =IF(A2=0, B2=0,""), I need when A2 is empty, for B2 to empty itself out. However, I need when A2 has something in it, for C2 to subtract the value from B2, but I can't if the formula doesn't stay put. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search in excel by date located in a cell | Excel Discussion (Misc queries) | |||
| using the name of a worksheet written in a cell, inside a formula | Excel Worksheet Functions | |||
| Can you dial a telephone number located in an cell? | Excel Discussion (Misc queries) | |||
| Using a value from a cell inside a formula! | Excel Discussion (Misc queries) | |||
| Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
Threaded Mode
