If you want to use if try this idea. Better to use VLOOKUP table. Look in
help index.
=k12+if(n512="ar",25,if(n512="ca",15,if(n512="fl", 33,0)))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Susan" wrote in message
...
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!