KrazySmile
New Member
- Joined
- Jan 9, 2005
- Messages
- 34
how can i get the remainder of a division on a formula?
(the equivalent to the % operator in C++, and Mod in VBA).
i have this:
=VLOOKUP(number;A1:B50;2;0)
what i want is that, instead of the value of 'number', i want it to search the remainder(rest) of the division of number/100, what in VBA, would b something like this (i gess):
aux = number Mod 100
thanks in advance
Filipe Silva
(the equivalent to the % operator in C++, and Mod in VBA).
i have this:
=VLOOKUP(number;A1:B50;2;0)
what i want is that, instead of the value of 'number', i want it to search the remainder(rest) of the division of number/100, what in VBA, would b something like this (i gess):
aux = number Mod 100
thanks in advance
Filipe Silva