Home Ask Login Register

Developers Planet

Your answer is one click away!

mrGreenBrown February 2016

Specific Excel function

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!


Sixthsense February 2016

Thanks for the clarification. Here is the excel formula.


Post Status

Asked in February 2016
Viewed 1,859 times
Voted 10
Answered 1 times


Leave an answer

Quote of the day: live life