Formula to get - Number is between specific Range

[Pravinkarne.31]

Hello Team,

Required you help ....

I have Salary (Col B) and Salary_Range (Col F), Tax Slab (Col G).
So here what I want is - Basied on Employee's Salary want to know Tax Slab applicable.

Please refer attached file for more details.

Thanks in Advance!

Thanks & Regards,
Pravin Karne

 

[Somendra Misra]

Hi Pravin,

See the file. Orange cells are helper cells.

Regards,

 

[Pravinkarne.31]

Thank you so much....Somendra for quick help.
Is there any way by which we can do it without adding helper column?

 

[Somendra Misra]

Hard code the values in formula like below:

=LOOKUP(B2,{0;5001;6001;7001;8001;10001},$G$5:$G$10)

in C2 and copy down:

Regards,

 

[Pravinkarne.31]

ok..Thank you so much!!!