Hi y'all.
I need help with some excel formulas, I tried everything but still could not find solution.Capture.PNG
I want to use CONCATENATE to join together A columng cities with Description from C colums. There is condition, if F column >25, I must first use City name and then Dentist, but if F column <25, first use Best Dentist in and then City name.
Do you have any suggestion? Which formula to use and how to make formula.
I use this formula =IF(F2<$F$1,"Best Dentist in "&A2&""), IF(F2>$F$1, ""&A2& "Dentist"), but get #VALUE!.
Thanks in advance!
Bookmarks