How to calculate
=ROUND(F4*IF(B4="194 C",0.1,0.02),0)
Regards,
Stefi
€˛Rao Ratan Singh€¯ ezt Ć*rta:
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
|