Using IF function in existing formula

[Chubszilla]

Hello,

I have a formula that pulls from sheet1 and adds a / in between the 2 words on sheet2.

=REPLACE(ACTExport!C2,4,0,"/")&ACTExport!B2

I want to use the IF function to only show ACTExport!B2 if ACTExport!C2=ACTExport!B2 but if not then show both.

Example. YYY/XXX but if XXX/XXX then only show XXX no backslash.

I am fairly new to using functions and formulas so any help is appreciated.

[Phuocam]

Try this ...
=IF(ACTExport!C2=ACTExport!B2,ACTExport!C2,REPLACE(ACTExport!C2,4,0,"/")&ACTExport!B2)

[Chubszilla]

Thanks this seems to work. Thank you.

[Phuocam]

You're welcome!