Thanks Folks
I owe you each a cyber beer ;0)
Problem ssorted.
Thanks again
Wibble

"Fred Smith" wrote:

In D3:

=B10*LOOKUP(B3,{5,10,50,100},{1,2,3,4})

You don't define what happens when B3 < 5, so you'll either want to make sure it
doesn't happen or test for it.
--
Regards,
Fred


"Wibble" wrote in message
...
Hi Folks........I know what I want but I don't know how to get it (oposite of
Anarchy in the UK :0)
This is what I am trying to do-
if B3 5<10 then D3 shows B10*1, if B3=10<50 then D3 shows B10*2, if
B3=50<100 then D3 shows B10*3, if B3=100 then D3 shows B10*4

Any suggestions please?

Thanks
Wibble