Let's say cell A1 is the single cell and that column C contains that normal
prices (un-discounted).

First enter .85 in A1 then copy A1 and paste/special/multiply into the
prices in column C. This will result in all the prices beith discounted by
15%
--
Gary''s Student - gsnu200713