| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can't find function error
I am trying to calculate a delivery date based on an vessel departure date on
my worksheet (K512) and the location (N512), adding a specific number of day for each location. My formula is below, and I continue to get a #VALUE! error. IF(N512="AR",SUM(K512+25)),"",IF(N512="CA",SUM(K51 2+15)),"",IF(N512="FL",SUM(K512+33)),"",IF(N512="I L",SUM(K512+25)),"",IF(N512="PA",SUM(K512+31))) ) I've spent 2 hours on this one formula - help please! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
| Find function returns the #VALUE! error value | Excel Discussion (Misc queries) | |||
| how to find an error | Excel Discussion (Misc queries) | |||
| help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
| Find and replace error | Excel Worksheet Functions | |||
Threaded Mode
