Beddy Boy
New member
- Joined
- Feb 1, 2017
- Messages
- 48
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
I wonder if anyone can help.
I have a table where a column of cells have a concatenate formula based on the value of 2 cells separated by a decimal point.
=CONCATENATE(B$5,".",Q3)
I wish to have the cells empty if there is no value in B5 and Q3. Obviously at present the columns are full of decimal points.
Is this possible?
Thanks in advance!
I have a table where a column of cells have a concatenate formula based on the value of 2 cells separated by a decimal point.
=CONCATENATE(B$5,".",Q3)
I wish to have the cells empty if there is no value in B5 and Q3. Obviously at present the columns are full of decimal points.
Is this possible?
Thanks in advance!