Hi,

Am Tue, 10 Sep 2013 17:17:06 +0100 schrieb shrimpy80:

If the number of sales is less than four, £0 is payable.
If the number of sales is 4 - 5, they are all payable at £4 each
If the number of sales is 6 - 9, they are all payable at £6 each
If the number of sales is 10 or more, they are all payable at £10 each
(The number of sales is totalled in cell H25)

try:
=H25*VLOOKUP(H25,{0,0;4,4;6,6;10,10},2,1)
modify the separators to your system


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2