How to use the excel if function to return a variable concatenated with a string?

If E1 is a cell, how do I return E1 dynamically concatenated with a string?

=IF(F1="not equal","update shop set url = E1 where id = A1","")

Answers


=IF(F1="not equal","update shop set url = " & E1 & " where id = " & A1,"")

Need Your Help

mod_rewrite returns 302 found

windows mod-rewrite apache2 apache-config

I have an apache 2.2 and I am using mod_rewrite. My objective is to forward traffic from

Cannot get postgresql-9.3-postgis-2.1 on Ubuntu 14.04.1 Docker container

postgresql docker ubuntu-14.04 postgis dockerfile

I tried to install postgresql-9.3-postgis-2.1 or postgresql-9.1-postgis-2.1 for a cloned app, but I can only get postgresql-9.4-postgis-2.1 on my Ubuntu docker image which is build from python:2.7 ...