SOLVED

Percentage increase giving error and wrong result

Brass 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.

 

https://1drv.ms/x/s!Ai3wejactZJ_licmHMLM2tBCbH7G?e=BPNseE

 

1 Reply
best response confirmed by packie (Brass Contributor)
Solution

@packie 

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

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

1 best response

Accepted Solutions
best response confirmed by packie (Brass Contributor)
Solution

@packie 

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

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

View solution in original post