Excel Formulas
By Raijem
@raijem (335)
Philippines
April 7, 2018 2:18pm CST
It’s a bit confusing when you have to versions of Microsoft Excel installed on your computer particularly if you are using formulas with it. I have a 2010 and 2016. With 2010, the separators for the formulas use commas (,) while in 2016 it uses the semi colon ( : ). This thing quite confusing when you use the Vlookup command. Probably will have to uninstall the 2010 and keep using the 2016. The struggle is real, particularly if you have certain sheets with that formula and it doesn’t work simply because the separator you used is the other one.
Anyone had this experience? Share your thoughts.
2 people like this
2 responses
@munhozmib (3837)
• Sao Paulo, Brazil
7 Apr 18
Greetings,
Well, it sure has some difference. For example, at my work there are desktops with 2003 and with 2013. I use the 2013 version, so the separator is the same, but there are a lot of resources added from 2003 and 2013. So, whenever a colleague asks for help and he/she is using the 2003, I'll find lots of difficulties.
Even though it's different, and even though we are used to an older version (of course, because the new version hasn't been used yet), I suggest you move on to the newest. It'll probably dictate new patterns.
From 2003 to 2013 it's not only about formulas. There are lots of shortcuts and hotkeys not working. There are lots of menus that were added only at 2013...
I'm sure you'll make it!
Regards.
@raijem (335)
• Philippines
7 Apr 18
Yes I agree. I have been using the newest. Hotkeys are another thing. I just thought I had to use the later version since most of my files have been created using the 2016 version and there had been some incompatibilities with 2010. It saves me disk space anyway. Cheers!
1 person likes this
