how to calculate Allowance

[Taps07]

HRA:
30%of basic salary if basic <=1000
25%of basic salary if basic>1000
here I applied the if condition...the formula is
=if(BasicSalary<=1000,BasicSalary*30%,if(basicsalary>1000,basicsalary*25%)

for Convey Allowance:
$50/-if Basic Salary is<=1000
$75/-if Basic salary is>2000
here instead of perc we have dollar so how to calculate this using please help me with this I got stuck

 

[Taps07]

HRA:
30%of basic salary if basic <=1000
25%of basic salary if basic>1000
here I applied the if condition...the formula is
=if(BasicSalary<=1000,BasicSalary*30%,if(basicsalary>1000,basicsalary*25%)

for Convey Allowance:
$50/-if Basic Salary is<=1000
$75/-if Basic salary is>2000
here instead of perc we have dollar so how to calculate this and below is the exmaple..I want to calculate CA Column

EmpId	Name of Employees	Basic	HRA	DA	CA	EA	PF	GIP	Gross
12902​	Ashish	25000​	6250​	7500​	2500000​	2500000​	1500​
12903​	Bharti	28000​	7000​	8400​			1680​
12904​	Chanchal	30100​	7525​	9030​			1806​
12905​	Dhirti	10000​	2500​	3000​			600​
12906​	Tanu	15000​	3750​	4500​			900​
12907​	Feanshu	40000​	10000​	12000​			2400​
12908​	Glory	90000​	22500​	27000​			5400​
12909​	Honey	24000​	6000​	7200​			1440​
12910​	Isiekil	12000​	3000​	3600​			720​
12911​	Japsim	70000​	17500​	21000​			4200​
	HRA: Basic Salary<=1000, BS*30% -- Basic Salary>1000 &Basic Salary<=3000, BS*25% -- Basic Salary>3000, BS*20%
	DA: Basic Salary*30% i.e. Fixed
	Convey Allowance: Basic Salary<=1000, BS*$50 -- Basic Salary>1000 & Basic Salary<=2000, BS*$75 -- Basic Salary>2000,BS*$100
	Entertainment Allowance: Basic Salary<=1000, BS*Nil -- Basic Salary>1000, BS*$100
	PF: Basic Salary*6%
	Group Insurance Premium: Basic Salary<=1500, BS*$40 --Basic Salary>1500&Basic Salary<=3000, BS*$60 --Basic Salary>3000, BS*$80