Variable issue: Calculation returns 0, which type to use?

Hi guys,

I am calculating something that should result in a value on in the range of 0 to 100.

Please Login or Register  to view this content.

Input is a integer between 1 and 5000000.

Problem: I am always receiving 0 in a test message box.

Am I using the wrong variable type or doing something wrong?

Working in VBA in Excel for Mac, v15.33

Hi Norie,

bolDebug is a boolean for debugging, which is declared in the workbook before this function.
I managed to get the calculation working.
By using this secondary step:

Please Login or Register  to view this content.

Whereas dec is another double variable.

Maybe someone else finds this useful or can shed some insight what I am doing wrong in the calculation.