I am willing to learn the lookup function, but this is a time sensative project. If you go to senario and choose new, then show, you will see that even though the correct percentage is calculated in the 1001 to 2000 range, when the math happens to calculate the new charge instead of a decrease I am getting an increase in charge. If you look at the senario itself I am using a negative value to lower the overall percent markup for that price range.(Look at the highlighted bold red field when you run the senario)

Thanks

Attached Files

ProblemSheet.xls (305.0 KB, 10 views)