I need to format some data in excel and I don't know how to write a very specific function and even worse, I don't know how to google it. The code in C-like programming language would be as the following:
x = x/100+x%100;
x = x;
I know the format of Excel formula, but something like this, certainly doesn't work:
Any help regarding this problem would be highly appreciated!