Forum Discussion
Solved
Percentage increase giving error and wrong result
Once I try to return 100% or more I get either an error or a minus result: 100% returns: #DIV/0! 150% returns: -100.00 Please see sheet for more information. https://1drv.ms/x/s!Ai3wej...
The formula in H5 should be =$D5*(100%+H$4)
This can be filled to the right, then down (or vice versa)
The formula in H5 should be =$D5*(100%+H$4)
This can be filled to the right, then down (or vice versa)