IF Addition

[John Persico]

I have the following formula in my spreadsheet:

=CONCATENATE('C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!D2,"
",'C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!E2)

It creates a product title, concatenating a Brand Name with a Product Name.

In the productindex file in Column F I have a ModelNumber field.

IF the ModelField has a (R) at the end of it, I wanted to add "REFURBISHED"
to the end of the formula above.

How can I insert an IF statement to make that happen?

--

 

[Joe User]

IF the ModelField has a (R) at the end of it,
I wanted to add "REFURBISHED" to the end of
the formula above. How can I insert an IF statement to make that happen?

First, there is no need to use the CONCATENATE function. Just use the "&"
operator.

I think you want the following:

='C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!D2
& " "
& C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!E2
& IF(RIGHT(C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!F2,3) = "(R)", " REFURBISHED", "")


----- original message -----

I have the following formula in my spreadsheet:

=CONCATENATE('C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!D2,"
",'C:\Users\John\Documents\Miscellaneous
Stuff\[productindex.xlsx]productindex'!E2)

It creates a product title, concatenating a Brand Name with a Product
Name.

In the productindex file in Column F I have a ModelNumber field.

IF the ModelField has a (R) at the end of it, I wanted to add
"REFURBISHED" to the end of the formula above.

How can I insert an IF statement to make that happen?