=SUMPRODUCT(--(H7>{180000;500000;800000}), (H7-{180000;500000;800000}), {0.1;0.1;0.1})

This is the basic excel formula.  Just copy it and paste in your excel worksheet.

Substitute 190000 for women and 250000 for senior citizen.

Replace H7 with the cell reference in which taxabe amount is present


Hope this formula simplifies your work.

Regards

CA. A. Joseph Arputharaj
27, Kamaraj Nagar
Panruti - 607106

Mobile:  9842677056