Here is what I did in real world (with calculator):
cost x 47% = ___ + cost = _____ x 4 = LP
What I need to accomplish in excel is one column holds the costs and can be
hidden and locked another column calculates the LP which I need to round up
to the next dollar (102.01 = 103.00). When I have a cost increase I would
like to put that percentage in one cell and have all the costs increase by
that percentange and then the list price automatically adjust accordingly.
Any Help?

"Boss Mary" wrote:

I have increased the prices on my price list by a %, now I need to roundup
the prices to the next dollar. I have three columns that are linked so that
when I increase the prices in one the prices in the other automatically
increase also. Can I round up the columns individually?