hi guyz how are u hope u will be fine and enjoy the life
A B C D
2 5 1% 100000
4 6 2% 200000

i want to make a formula which show me when d 100000 greater then or equal to 2 and b equal to and greater then 5 then it show me 1% in e colume other wise show me 0

and
if a=> 4 and 6=> 200000 then show me 2% in e colum plz letme know how can i sort it out with the help of formula

thanks in advance