| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
error message "#VALUE!" due to blank cells
Hi All,
I am trying to have a spreadsheet where i check the delivery time on orders (attached a picture). Essentially, it calculates the difference between the "Promised Date (A1)" and the "Atual Date (A2)" i.e. A1-A2 The problem is where is have blank cells with no information yet. then i get the nice error message "#VALUE!" Can anyone help in having these cells show nothing instead of the error message? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what does error message "too many adjustable cells" mean in solver | Excel Discussion (Misc queries) | |||
| Error message "cannot shift nonblank cells off the worksheet" | Excel Discussion (Misc queries) | |||
| Display message if "find" command comes up blank ?? | Excel Programming | |||
| Error Message "Runtime error '13' Type mismatch" | Excel Programming | |||
| Adding more than 3 cells (2003)produces "0" but no error message | Excel Worksheet Functions | |||
Threaded Mode
