| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula value display
You're welcome. Thanks for the feedback!
Biff "drk442" wrote in message ... this worked, thanks a lot "Biff" wrote: Try this: A1 = 100 B1 = 25 C1 = formula: =IF(B1="","",A1-B1) Copy down as needed. A2 = formula: =IF(C1="","",C1) Copy down as needed. Biff "drk442" wrote in message ... I have a a spreadsheet where I substract column B from A and show results in C. Then C is sent to column A one row down. When I drag the formulas down so that they repeat I get an entry in column A & C. Is there a way to not have the formula value show up until an entry is entered in Colum B? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
| how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
| formula to display choices of more than one in a list box | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hybrid Mode
