"Biff" wrote in message
...
Hi!

Here's one way:

Assume cell A1 is the total cost.

=IF(A1="","",LOOKUP(A1,{0,250,500,1000},{7,10,12,1 5}))

Format the cell as NUMBER 2 decimal places.

Biff


Where did that post come from? It wasn't there when I looked 10 minutes ago
<g


Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk