|
How to calculate
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 |
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 |
How to calculate
Thank you steffi.
"Stefi" wrote: =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 |
How to calculate
You are welcome! Thanks for the feedback!
Stefi €˛Rao Ratan Singh€¯ ezt Ć*rta: Thank you steffi. "Stefi" wrote: =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 |
| All times are GMT +1. The time now is 10:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com