Forum Discussion
Excel returns #VALUE for a simple multiplication by a percentage
Hi, just got Excel 16.17 for Mac. Something is maddeningly wrong, i cannot perform a simple multiplication, either by a percentage or by a number with decimal. Multiplications of full number are ok, ...
LetoA655 Are you sure your system is set-up to work with decimal points and commas as list separators? Perhaps you need commas for the decimal and semi-colons as the separator.
Try changing the number in K2 to 0,016 (and make sure the cell is formatted as a number).
With regard to the formula "=percentage(E4,1.6%)", are you calling a user defined function? If so, try =percentage( E4; 1,6% )