Excel if function

[linnzayar]

Dear all, I wold like to ask some question that make me difficult to use excel " IF" I would like to write "IF" function in my Excel data. The following is that I would like to write. If A1 is less than 1351 A2=1000, If it is greater than 1351 and Less than 2000, A2 =2000, If it is greater than 2000 and Less than 5000 A2 = 3000. If it is greater than 5000, A2 = 4000 this is what i would like to write with "if fucntion) thank a lot

 

[njimack]

Welcome to the board. The below formula should be what you're after:
=LOOKUP(A1,{0,1351,2000,5000},{1000,2000,3000,4000})

 

[linnzayar]

Welcome to the board. The below formula should be what you're after:
=LOOKUP(A1,{0,1351,2000,5000},{1000,2000,3000,4000})

Thank very a lot for your reply

but I really understand it as i am the basic user of excel

Please reply with full function.

I would like to write it

If A1 is less than 1351, A2 is A3*0.5*0.83333
if A1 is greater than 1351 and Less than 2001, A2 is A3*0.8*0.83333
if A1 is greater than 2001 and less than 5000, A2 is A3*0.83333
if A1 is greater than 5000, A2 is A3*1.2*0.83333

thank again

I am waiting your kind reply

 

[njimack]

Thank very a lot for your reply

but I really understand it as i am the basic user of excel

Please reply with full function.

I would like to write it

If A1 is less than 1351, A2 is A3*0.5*0.83333
if A1 is greater than 1351 and Less than 2001, A2 is A3*0.8*0.83333
if A1 is greater than 2001 and less than 5000, A2 is A3*0.83333
if A1 is greater than 5000, A2 is A3*1.2*0.83333

thank again

I am waiting your kind reply

That seems a really inefficient method, but here you go...

=A3/1.2*LOOKUP(A1,{0,1351,2000,5000},{0.5,0.8,1,1.2})

 

[linnzayar]

that seems a really inefficient method, but here you go...

=a3/1.2*lookup(a1,{0,1351,2000,5000},{0.5,0.8,1,1.2})

very very thank for this reply

it is work now, i will say you after all test.