Work it out like this
a) Value
b) Custom duty = value*0.2
c) Value + Custom Duty =value*1.2
d) Sales Tax = Value *1.2*0.16
e) value +custom duty +Sales tax =value*1.2+Value *1.2*0.16
= value*1.2*1.16
=value*1.392
f)Income Tax =value*1.392*0.06
g) value +custom duty + sales tax + income t
Hi Rasheed,
Use this
=SUM(IF((A1:A8="custome duty")+(A1:A8="sales tax")+(A1:A8="income
tax"),C1:C8,"")) with ctrl+shift+enter.
On Tue, Feb 19, 2013 at 1:18 PM, Rasheed Razzaq wrote:
> Dear Experts,
> I need a formula or function for calculation of Taxes in single cell.
>
> Val
Dear Experts,
I need a formula or function for calculation of Taxes in single cell.
Value 1,000,000
Custom Duty 20%
Sales Tax 16% x (Value+Custom Duty)
Income Tax 6% x (Value+Custom Duty+Sales Tax)
*Required Value (Custom Duty+Sales Tax+Income Tax)*
Is there any single formula
or
function where