Forum Discussion
Ricard_1967
Mar 26, 2020Copper Contributor
Fórmula Excel
I have a formula that is not well programmed and the structure does not support me. I need excel to add according to a condition if there is a "slight reason" add 2 years to the cell of a date ...
- Mar 26, 2020
Perhaps you shall use semicolons instead of commas. Please open the file I attached to previous post, that will be correct formula for your locale, Excel transforms it automatically.
Ricard_1967
Mar 26, 2020Copper Contributor
SergeiBaklan I have corrected the curved commas but the error gives me in cell E3 that does not support it. I don’t understand this error.
SergeiBaklan
Mar 26, 2020Diamond Contributor
Perhaps you shall use semicolons instead of commas. Please open the file I attached to previous post, that will be correct formula for your locale, Excel transforms it automatically.
- Ricard_1967Mar 26, 2020Copper Contributor
Magnificent ... I had not thought of this syntactic detail.
Thank you very much for your contribution, and in general, thank you very much for all the help received in this post.
- SergeiBaklanMar 26, 2020Diamond Contributor
You are welcome, glad to help