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, but as soon as I type =E4*K2 (see attached screenshots), I get a #VALUE error. I also tried entering the calculation manually, as in =25920*K2, or =25920*0.016, or even =percentage(E4,1.6%) and those return a "There is a problem with this formula" error message.
Every cell in the formula is either in general or percentage format, and I also tried in number format. There is no extra space in any of the cells. The calculation mode is set to automatic.
Please help, this is an extremely basic function that is needed everyday, I'm going crazy.
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% )
