Forum Discussion
looking for help pls
Hi,
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!
As variant you may have non-printable character in I5 if you copy/paste value here, for example it could be reproduced as
As variant you may have non-printable character in I5 if you copy/paste value here, for example it could be reproduced as
SergeiBaklan , thanks for your help. it works 🙂
vtang , you are welcome, glad it helped
