Excel formula help!

[vass_sam]

Machan pls help me to find formula to meet following conditions
1.salary up to 27184-0%
2.27184 to 54347-4.6% less 1250
3.54347 to 72463-9.2% less 3750
4.exceding 72463-13.8% less 7084

Machanz pls help me

 

[vass_sam]

Pls help me machnz this is urgent!

 

[TΞΞNSTAR™]

http://www.google.lk/search?hl=en&q=excel+formulas&btnG=Google+Search&meta=

Try to get help frm here!!!

 

[vass_sam]

Google search kara banz

 

[vass_sam]

Ane banz kawruth naddo!

 

[jayanthah]

Try ekak dennam, ethakn meka tikak explain karanawada?

 

[nEoN_wHitE]

aiyo dan mama work yanawa... rata ena kotath help ekak thibe natham mama post karanam..echara amaru na meka

 

[vass_sam]

aiyo dan mama work yanawa... rata ena kotath help ekak thibe natham mama post karanam..echara amaru na meka

Aiyo!OK Will see.Thanks machanz!

 

[vass_sam]

Hafoi kawrvh naddo!

 

[Pura Pagal]

Machan pls help me to find formula to meet following conditions
1.salary up to 27184-0%
2.27184 to 54347-4.6% less 1250
3.54347 to 72463-9.2% less 3750
4.exceding 72463-13.8% less 7084

Machanz pls help me

Please post your comments (if any) in ENGLISH


Kindly look at the illustration below

Please copy paste this formula
=IF(B15>72463,B15-(B15*13.8%+7084),IF(B15>54347,B15-(B15*9.2%+3750),IF(B15>27184,B15-(B15*4.6%+1250),B15))) in C15, and use the fill handle to copy it in the range C16:C24, as soon as you enter figures in the range B15:B24 the calculated result would display in the corresponding cell (Column C)

Hope this would suffice. Any problems please PM

 

[dilckavee]

incometaxda?

 

[wdishan]

Herewith attached

Herewith attached

 

[wdishan]

Herewith attached

Formula


=+IF(B6<27184,B6,IF(AND(B6>=27184,B6<54347),(B6*104.6/100)-1250,IF(AND(B6>=54347,B6<72463),(B6*109.2/100)-3750,IF(B6>=72463,(B6*109.2/100)-3750,0))))

 

[vass_sam]

Formula


=+IF(B6<27184,B6,IF(AND(B6>=27184,B6<54347),(B6*104.6/100)-1250,IF(AND(B6>=54347,B6<72463),(B6*109.2/100)-3750,IF(B6>=72463,(B6*109.2/100)-3750,0))))

Thankz macho!

 

[Kishin]

hmmmmm......