Using an IF statement to combine text with a variable.

[bullrunpremier]

Failing at every turn to get the correct formula.

IF cell P1 contains the word Delivery concatenate 3 cells together. This I have been able to do. but adding If Cell P1 is equal to Pickup then merge these 3 cells. When it says Delivery im good but otherwise I will get a False return instead.

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

 

[Joe4]

Welcome to the Board!

If you checking for two conditions, you need to do a nested IF, i.e.
=IF(P1= "Delivery",do this,IF(P1="Pickup",do that,do nothing))

 

[steve the fish]

Hi. Maybe you mean this?

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

 

[Fluff]

Hi & welcome to MrExcel
Is this what you need
=IF(P1="Delivery",Q1&" "&AE1&" "&AI1,IF(P1="Pickup",Q1&" "&AF1&" "&AJ1,""))