Hi, 

@vtang 

I have this formula in this a new worksheet. The formula is tested and the result is what i expected to be. But when I copied the formula to an existing workbook, it becomes #value!  I’m not sure what has gone wrong. could you pls help me? 

=IF(J6=”December”,CONCATENATE(“Y”&RIGHT(I5,4)-1),CONCATENATE(“Y”&RIGHT(I5,4)))

new worksheet – tested and result expected

existing workbook – tested but result is #value!

​Hi, @vtang I have this formula in this a new worksheet. The formula is tested and the result is what i expected to be. But when I copied the formula to an existing workbook, it becomes #value!  I’m not sure what has gone wrong. could you pls help me? =IF(J6=”December”,CONCATENATE(“Y”&RIGHT(I5,4)-1),CONCATENATE(“Y”&RIGHT(I5,4)))new worksheet – tested and result expected existing workbook – tested but result is #value!  Read More

​