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
Bookmarks