try this

=IF(AND(A2=0,A2<=100),A2*2,IF(AND(A2100,A2<=200) ,A2*3,""))


On Nov 17, 3:43*pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3

Can anyone help please