My problem is this that, my first column contains PAN No's of my Vendors, the second column contains the bill amount. Now I want to deduct TDS @1% in the case of persons(evidenced by the fourth letter of the PAN, which will show "P") and TDS @ 2% for the rest. The obvious option is to use the MID formula and extract the fourth letter of the PAN and then apply IF formula.
But is there a more simpler and neater way?
Just curious....
I've uploaded the file and my way of dealing with it for your reference
But is there a more simpler and neater way?
Just curious....
I've uploaded the file and my way of dealing with it for your reference
