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