Hello everyone!

When I created a speadsheet I wanted to multiply number in a sheet( 0.5) with a percentage in a sheet (40.49) and it gives me #VALUE! error. Does someone know a solution to this problem? Interestingly I was playing around with it quite a while and I can calculate percentages like 52%*38% but cannot do the same if I add decimals( example: 51.1%*38%)