Hi Guys,

I'm using =concatenate(A2,".",B2,".",C2) in Column D. But when I drag it
down from cell D2 down I get same values.

Column A Column B Column C Column D Vlaues in Column D
sould be
15007 5709 15007.5709.
15007.5709
18090 5015 300 15007.5709.
18090.5015.300

I want:
1 - When Column C is blank then do not use decimal at the end of the numbers
in column D;

2 - When I drag the formula down from cell D2 it change with the vlaue in A,
B and C column.

Will appreciate your feedback.

Thanks