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.
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.
absolutely it is this……what I am looking for….THANKS, THANKS, THANKS………Sir, you have saved my lot of time. Hope you will be in touch with me in future too. My email id is nisar5346@gmail.com & I am on fb too, my name is Nisar Rukadikar.