| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Errors
Is it possible to supress the error sign created when a
field is left empty or the date returning as 1900 and display a field as empty but keep the formula until data is present? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Empty Errors
Hi
may be use something like =IF(A1="","",your_formula) -- Regards Frank Kabel Frankfurt, Germany "Don Cleve" schrieb im Newsbeitrag ... Is it possible to supress the error sign created when a field is left empty or the date returning as 1900 and display a field as empty but keep the formula until data is present? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Empty Errors
Yes but there is a problem with
=IF(K5<0,68,69) which I use as a formula. Is it possible to use a double If like IIF for this one? Thanks again -----Original Message----- Hi may be use something like =IF(A1="","",your_formula) -- Regards Frank Kabel Frankfurt, Germany "Don Cleve" schrieb im Newsbeitrag ... Is it possible to supress the error sign created when a field is left empty or the date returning as 1900 and display a field as empty but keep the formula until data is present? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Empty Errors
Hi
not quite sure what you're trying to do but try =IF(K5="","",IF(K5<0,68,69)) -- Regards Frank Kabel Frankfurt, Germany "Don" schrieb im Newsbeitrag ... Yes but there is a problem with =IF(K5<0,68,69) which I use as a formula. Is it possible to use a double If like IIF for this one? Thanks again -----Original Message----- Hi may be use something like =IF(A1="","",your_formula) -- Regards Frank Kabel Frankfurt, Germany "Don Cleve" schrieb im Newsbeitrag ... Is it possible to supress the error sign created when a field is left empty or the date returning as 1900 and display a field as empty but keep the formula until data is present? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
| Can blank cells created using empty Double-Quotes not be empty?? | Excel Programming | |||
Linear Mode
