Try this paste into D3
=IF(AND(B35,B3<10),B10*1,IF(AND(B3=10,B3<50),B10 *2,IF(AND(B3=50,B3<100),B10*3,IF(B3=100,B10*4,"" ))))


"Wibble" wrote:

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