If row 9 represents a product, what in this row tells us it is a limited
discount item?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Duncan, UK" wrote in message
...
I am trying to cap a cell that I use for discounts.
eg the cell could read 35%, but I only want a max of 30% on some products
I am using a cell to input a discount into quotations, this cell is then
used to calculate sums further below eg
g24 = 40%
and I use =(E9*F9)*(1-$G$24) later to get my total BUT I want to be able
to
cap some lines with a lower discount eg some products can have up to 40%
,but
others can only go up to 30%.
=MIN(SUM(A1:A10),100) This sum works if the cell is formatted as a
general
number, but not if it is formatted as a percentage.

Help please...