Percentage increase giving error and wrong result

[packie]

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!Ai3wejactZJ_licmHMLM2tBCbH7G?e=BPNseE

[#2 · Accepted solution]

@packie 

The formula in H5 should be =$D5*(100%+H$4)

This can be filled to the right, then down (or vice versa)