Adding number for different amount

[solloman]

i was reading help in office it was like that but the formula doesnt work for me. Please help me to fix it.
=IF(e2-e3>5999<8000, "100",IF(e2-e3>7999<10000,"200", IF(e2-e3>9999,"400"))))
its mean after 5999 to 8000 the cell will apear like 100, 7999 to 10000 as 200, 10000 for up as 400.

[dilipandey]

Hi solloman,

Try using the below formula:-

=IF(AND(E2-E3>=5999,E2-E3<=7999),100,IF(AND(E2-E3>=8000,E2-E3<=9999),200,400))

Regards,
DILIPandey

<click on below 'star' if this helps>

[solloman]

Its the same error in the formula =IF(AND(E2-E3>=5999,E2-E3<=7999),100,IF(AND(E2-E3>=8000,E2-E3<=9999),200,400))
Check by yourself if you made a mistake.

[vlady]

you can also use this

=IFERROR(LOOKUP(E2-E3,{6000,8000,10000},{100,200,400}),"")

what will be the value if lower than 6000 - 0?

=IFERROR(LOOKUP(E2-E3,{0,6000,8000,10000},{"value here",100,200,400}),"")

[solloman]

its say the formula isnt correct, try to put it by your self on the red cell. Pleease

MASKORET SHVUIT.xlsx

[vlady]

you have an error message??

ok. your'using different kind office..
change all the comma , with this ;

[Paul]

Solloman,

Please take a moment to read the forum rules (link in my signature below) and then amend your thread title to something descriptive of your problem.

If you plan to post another question - keep that in mind.