Question regarding IF statement.

[bullrunpremier]

I run this and I get it 1/2 right. If Delivery part seems to work. But when its not Delivery I get a False return. Not choosing any other options beyond. help? I added Pickup and regardless if I add or remove that The second solution is never provided.

=IF(P1="Delivery","Pickup",&Q1&" "&AE1" "&AI1", Q1&" "&AF1" "&AJ1)

[#2]

@bullrunpremier 

Perhaps you mean

=IF(P1="Delivery",Q1&" "&AE1&" "&AI1,IF(P1="Pickup",Q1&" "&AF1&" "&AJ1,""))

[#3]

@bullrunpremier IF has three arguments: the logical test, the value if TRUE, and the value if FALSE. These arguments are separated by commas. Try removing the comma between "Pickup" and &Q1.

Formula without extra comma:

=IF(P1="Delivery","Pickup"&Q1&" "&AE1" "&AI1", Q1&" "&AF1" "&AJ1)

Let me know if it works.

Thanks,

Yvette