Putting text/string function within an if function

Question

I am trying to put a text function inside another function (if statement) in excel:

=IF(C1 <> 0, ="INSERT INTO [dbo].[GPI_ASOC] ([GPI],[THER_CLASS_DESC],[GENERIC_NAME]) VALUES ('" & TEXT(A1,0) & "', '" & TEXT(C1,0)  & "',  '" & TEXT(D1,0) & "');", "FAIL")

If C row# <> 0 make the field say FAIL if not make the cell show the insert statement.

Edit: does not = 0 (<>)

In Excel, the syntax for "does not equal" is <> instead of != — tigeravatar
– tigeravatar, Commented Jan 26, 2017 at 19:32
@ScottCraner Well, now I feel silly. I didn't realize it would evaluate without telling excel its a function. — David Tunnell
– David Tunnell, Commented Jan 26, 2017 at 19:34
You did tell Excel it was a function with the first = all others are assumed. — Scott Craner
– Scott Craner, Commented Jan 26, 2017 at 19:36

singhsac · Accepted Answer · 2017-01-26 19:36:02Z

1

Try this:

=IF(C1 <> 0, "INSERT INTO [dbo].[GPI_ASOC] ([GPI],[THER_CLASS_DESC],[GENERIC_NAME]) VALUES ('" & TEXT(A1,0) & "', '" & TEXT(C1,0)  & "',  '" & TEXT(D1,0) & "');", "FAIL")

answered Jan 26, 2017 at 19:36

singhsac

5011 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Putting text/string function within an if function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related