IF Addition

  • Thread starter Thread starter John Persico
  • Start date Start date
J

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?

--
 
John Persico said:
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?
Click to expand...

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

John Persico said:
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?
Click to expand...
 
Back
Top