FALSE answer displayed on formula - should work!

Hi All - Newbie to the Forum here!

I am trying to get a Nested IF formula to work, but only one side of it seems to work and the other side gives me a FALSE

=IF(N14="Q",SUM(G1+(VLOOKUP(M1,'Free Time Deals'!$C$4:$L$50,6)-1),IF(N1="L",SUM(J1+(VLOOKUP(M1,'Free Time Deals'!$C$4:$L$50,2)-1)))))

It is fairly simple, all I am trying to do is look up an agreed figure (a date) and add onto it from an array the figure that corresponds to the record. I have managed to get it to calculate correctly when N1="Q" but if N1="L" the return is FALSE.

I have tried just using a single IF, THEN combo (below) but this gives me the same issue

=IF(N1="Q",SUM(G1+(VLOOKUP(M1,'Free Time Deals'!$C$4:$L$50,6)-1),SUM(J1+(VLOOKUP(M1,'Free Time Deals'!$C$4:$L$50,2)-1))))

Any ideas would be gratefully received!!

Simon

Hi Guys

N1 should return a blank or a zero if it doesn't meet either criteria.

I should say that G1 or J1 are dates and I am trying to add a fixed number of days to that, for example - if G1 is 02/01/2013 and N1 = "Q" then it needs to add 15 days.or if "L" it needs to add 7 days to J1

=IF(N1="Q",G1+VLOOKUP(M1,'Free Time Deals'!$C$4:$L$50,6)-1,IF(N1="L",J1+VLOOKUP(M1,'Free Time Deals'!$C$4:$L$50,2)-1),"")

the formula above just gives me a #VALUE Error

I know that sometimes I overthink it!

Simon

Hi There

Attached the file showing what i want it to do - the only two responses will be Q or L.

What I am trying to do is create a file where I import from our software the containers we have for delivery and it shows what the date the container should be back on quay is (column O)

The parameters are dates from Landing (L) and date off quay (Q)

Different shippers give us different rates and these constantly change so the requirement to be able to adjust the rate is why I need a seperate sheet.

You may say "wow - so complicated, here is an easier way to do it!" - and I will be grateful!!

Regards
Simon

Thanks to all those who helped - I knew you would!

Just one misplaced parenthesis!

Thanks Again

Simon