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

Scrabble Value calculation for Welsh words 0
Calculate the difference betwen two columns -two dates 3
Find and match totals Genius Req. this should be easier to read 1
Calculate the value of Z 12
How to change this macro 8
How to Calculate the Interest rate 2
Basic question - how to calculate a cumulative percentage 2
Formula to calculate the data of the last order 1

Top