Find Conditional Percentage of sum of multiple cells

[SAJIL RAHMAN]

TYPE1	TYPE2	TOTAL1	TOTAL2	PERCENTAGE
E	BT	50000	50000	I NEED TO CALCULATE 3% OF SUM TOTAL1 &2 IF TYPE 1 IS "E/F/O" AND TYPE2 IS "DT"... IT SHOULD BE 5% IF TYPE1 IS "E" AND TYPE2 IS "BT"
E	DT	50000	50000
F	DT	150000	50000
O	DT	250000	50000

<tbody>
</tbody>

Please help me to find the suitable formula, i tried my best last 2 days....

 

[Aladin Akyurek]

Apply ROUNDUP to the percentage formula: ROUNDUP(percentageformula,0)

 

[Aladin Akyurek]

Apply ROUNDUP to the percentage formula: ROUNDUP(percentageformula,0)

Geez. That should be: =ROUND(percentageformula,0)

 

[dave2018]

both has given my answer, while i have chosen your formula because it helps me to make some changes and to give more additional options.
Could you please help me that i need to round the answer, i tried to change the formula but failed, please provide me the same above formula with rounding facility. (>.5 to 1/ <.5 to 0)

=round(if(and(a2="e",b2="bt"),sum(c2:d2)*5%,sum(c2:d2)*3%),0)

Edit: Oh. I see Aladin has already answered you. my bad.

 

[SAJIL RAHMAN]

=round(if(and(a2="e",b2="bt"),sum(c2:d2)*5%,sum(c2:d2)*3%),0)

Edit: Oh. I see Aladin has already answered you. my bad.

once again Thank you Deve & Aladin