Nested If?

[Philatelist]

Hi Guys, I have an application with a max cell entry of 250 characters.

If cell BA2 has a string with more than 250 characters, I need it shortening to 200 and the phrase "......details below" (without apostrophies) adding to the end, otherwise, if less than 250, just the string .

So far I have:

=IF(LEN(BA2>250),LEFT(BA2,200)&(AZ10)),BA2 (Where AZ10 = ".....details below")

No matter how many characters the cell contains, I cannot get the formula to stop the additional text appearing if less than 200.

Please help!

TIA

 

[Phuoc]

Maybe like this

=IF(LEN(BA2)>250,LEFT(BA2,200)&AZ10,BA2)

 

[Philatelist]

Another first time fix. Perfect answer, many thanks.

This Board is amazing.

 

[Fluff]

@Philatelist in future please mark the post that contains the solution, not your post saying it works. Thanks

 

[Philatelist]

Will do, my apologies