Thread: Excel Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pravin Chalise Pravin Chalise is offline
external usenet poster
 
Posts: 1
Default Excel Formula

Yrly IncomeTax (15%)Tax (15%) Net Yearly
204000 30600 Tax Payeer ?
72000 10800 Non Tax Payeer ?
3400 510 Non Tax Payeer ?
176000 26400 Tax Payeer ?
162000 24300 Tax Payeer ?

Q.is if yrly income is 150000 add 25%, if it is more than 200000 add 30%
and if yearly income is less than 149000 do not add tax. Solve the problem.
Thanks...
Pravin