Hi Good Day, is there someone can guide me to right direction on how can i achieve this thing.
I have a list of range compensation for deductions for example the range compensation amount is from 8,250 to 8,7499 this is the bracket. When i have a salary of 8,500 which is under the bracket list i will get the amount of 340. How can i achieve this? Using formula or condition. Thanks.