OK, let's start with the logic.

If the user enters a different number than is the total then you wan
Excel to do something - that's easy enough.

The question is, what do you want Excel to do?

If the variable relates to the number or size of tubs, then you coul
use Vlookup.

EG if the difference between the total and what the user entered i
one(as in your example) you could have a table that says

1= Fiesta 9oz
2= Fiesta 9oz + Fiesta 4oz

and so on.

Or did I miss the point by a mile?!

Coli

--
Colin Vicar
-----------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=39075