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 ...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.