| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display of formula result
Is it possible to have a formula result not display unless all data is entered?
For example: (A1+A2)+2, the result is always displayed as "2" until cells A1 and A2 are given values. I need the results cell to remain empty until A1 and A2 are filled in. Is this possible in Excel 2003? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display of formula result
Hi Kerri
various ways of achieving this Try =IF(COUNT(A1:A2)<2,"",A1+A2+2) -- Regards Roger Govier "KerriBarsh" wrote in message ... Is it possible to have a formula result not display unless all data is entered? For example: (A1+A2)+2, the result is always displayed as "2" until cells A1 and A2 are given values. I need the results cell to remain empty until A1 and A2 are filled in. Is this possible in Excel 2003? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display of formula result
Thanks so much, Roger! Your suggestion worked perfectly!
"Roger Govier" wrote: Hi Kerri various ways of achieving this Try =IF(COUNT(A1:A2)<2,"",A1+A2+2) -- Regards Roger Govier "KerriBarsh" wrote in message ... Is it possible to have a formula result not display unless all data is entered? For example: (A1+A2)+2, the result is always displayed as "2" until cells A1 and A2 are given values. I need the results cell to remain empty until A1 and A2 are filled in. Is this possible in Excel 2003? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display 0 if it is the end result for a formula | Excel Discussion (Misc queries) | |||
| Display result in same cell as formula | Excel Discussion (Misc queries) | |||
| Display result of formula in header? | Excel Discussion (Misc queries) | |||
| Formula is entered but will not display result | Excel Worksheet Functions | |||
| How do I display the RESULT of a formula | New Users to Excel | |||
Linear Mode
