View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 271
Default 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!