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