If function


Please refer attached sheet & let me know correct formula that will count Tax cell (C10) amount correctly according to Earning cell (B10) amount AS PER THE SLAB MENTIONED.

Thanking you in advance, hope you will favour me by responding.

5 thoughts on “If function”

  1. hi there, you should change the values in B5:B7 as such:
    B5: 0
    B6: 5001
    B7: 10001

    then do a VLOOKUP with approximate match. the last argument in VLOOKUP is usually using FALSE, meaning an exact match. this time, do not put anything in the last argument. that will find an approximate match.

    what it does is to use the value in B10 to search for an exact match in B5:B7. if it doesnt find an exact match, it looks for the next largest value that is LESS than the lookup value & return the value in Column C.

    hope that helps.

  2. Thanks a lot for solution & it really worked. But is there any other way considering only 2 cells. Means suppose if the amount in B10 CELL is below Rs 5000/- then C10 CELL should show Rs 00.00 as tax amount, B10 CELL amount is between Rs 5001 to 10000 then C10 CELL should show Rs 175/- as tax amount & if B10 CELL amount is Rs 10001 & above then C10 CELL should show amount of Rs 200/-. Sorry for putting you in trouble but your solution will help me a lot. Thanks & good night(I am in India)

Leave a Reply