I tried attaching the file but was unable to. However click below to see the complete trick
Menu
Derivation of Income Tax Formula in seconds
Replies (4)
provide your valuable comments here please
was it of any help let me know
thank you
Your tricks seems complicated....but i will reply u soon abt it....also ur effort is appriciated....
Let assume E530 inthe given formula is Rs. 600000
then apply the given formula
=ROUND(IF(E530>500000,54000+(E530-500000)*0.3,IF(E530>300000,14000+(E530-300000)*0.2,IF(E530>160000,E530*0.1,0))),0)
= Rs. 84000
| Originally posted by : Jayesh | ||
 |
Your tricks seems complicated....but i will reply u soon abt it....also ur effort is appriciated.... |
 |
No it is easy actually. May be my presentation is not that good.
Recent Threads
- Login credentials and payment acknowledgement not
- Export sales not realised payment not received fro
- Capital gain account amount utilisation
- Form 26QB – Section 194-IA: TDS on Full Cons
- Indexation Benefit available or not on Calculation
- Documents for return exhibition material
- Can I set off equity losses(both short term loss a
- Input tax credit on rent to rent
- Family Pension Army
- Waste Management services
Related Threads
CAclubindia
