How to calculate

R

Rao Ratan Singh

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
 
S

Stefi

=ROUND(F4*IF(B4="194 C",0.1,0.02),0)

Regards,
Stefi

„Rao Ratan Singh†ezt írta:
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„Rao Ratan Singh†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
How to Create an S-Curve from Custom Field? 0
Calculate the difference betwen two columns -two dates 3
how to get the percentage symbol with the result? 3
Conditional lookup 2
calculations help 1
How to open multiple instances of Word 365? 5
How to change this macro 8

Top