Hi all,
I want to calculate TDS. But i have to two types of TDS like 2% and 10%.

for Exampes

B F H
Deductee Code Amount TDS

194 C 15000.00 =IF(B4="194
C",ROUND(H4*10/100,0),0)Otherwise 2%
194 C
194 J

How i should use this formula to deduct right percentage based on deductee
ode.

Regards