Percentage increase giving error and wrong result

Copper Contributor

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


1 Reply
best response confirmed by packie (Copper Contributor)


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

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