Yes. Use Solver.
--
Gary''s Student - gsnu200815


"john" wrote:

Hello
could somebody tell me if its possible in excel 2007 to write a formula that
produces a figure but can produce another figure if the original is not whats
required
eg if the price of sugar is 5pence and i want 1 =5pence but if i want more
than 100 i would expect a discount meaning the figure produced is wrong and
should be another lower figure