I am needing to add a SUM formula to a cell to do the following: Cell B2 is
number of adults at $3.00 each, C2 is number of children at $1.50 each and D2
will be the total of B2, C2 but I need to set a Maximum amount of $9.00, ie
if B2 is 3 (3 x $3.00 = $9.00), and C2 is 3 (3 x $1.50 = $4.50) I need for D2
to be $9.00 instead of $13.50 (B2, $9.00 + C2, $4.50 = D2 $13.50). How do I
format the cell so it knows the maximum amount to put in the cell is a
certain amount, maybe something to do with the < sign's?

I'm running Windows XP SP2 with Excell 2000 ver. 9.0.2720