Dear Peter,

Would you please be more spcecific in instruction. :-)
I fail to understand "Insert, Name, Define". What are
exact actions I should undertake?

Thankx in advance! ;-)

Michael.

-----Original Message-----
Michael

Try Insert, Name, Define. Give this the name Markup and
in
the Refers to text box type 2.5 to mark up the Price by
250%.
In the Sales price column type B2 * Markup

You can then hide the colun with the Purchase Price and
Protect the worksheet.

Regards
Peter
-----Original Message-----
Is there any way to forbid users to see data in some
cells while the program still can use these cells for
make calculations?

The main idea is the following. I make a price list for
our distributors. There is a column with base prices
which are multiplied by a certain ratio with final
prices
column as the result. Is there any solution to hide the
base prices so the end users won't be ever able to
discover them?

Michael.
.

.