30%

How To Set deduction cumulative percentage from 01/08 to 30/08 If employee late in arrival more than day and finish this work If attendance in 02/08 is 08:30 is deduction is 10% And attendances 03/08 09:15 deduction is 30% need to be 10 + 30 = 40% and do that for all month date...

sir, This is Income Tax calculation where for 1st 2,50,000 rupees no tax. For the next 2,50,000 rupees tax is 5%. Above 5 lakh but below 10 lakh tax, it is 20%. Above 10 lakh, tax is 30%. if taxable income is 450000(4.5 lakh) for 250000 nil tax upto 500000 5%...

I need to calculate some weighted percentages with the following criteria: If X=70% then I multiply 80% of 30% If X=75% then I multiply 100% of 30% If X=80% then I add 10% to the 30% Anything beyond 80% is at most 40%. How do I calculate what this percentage will be if say for example, X =...

I am trying to accomplish the following; Cell C11 Change to 50%, 40%, 35% or 30% if cell C10 is 50,000, 100,000, 150,000, 200,000

Hello! I need to be able to add a gradient if one fee is 10% higher to 30% higher than the base cost or 10% lower to 30% lower than the base cost. Example: I have a base cost of $15. Different comparison costs are $10 and $20. I need to be able to add a gradient color depending on the...

I wish do a formula to calculate the percentage with these conditions stated below: 0 - 8,555.5 = 0% 8,555.51 - 10,000 = 15% 10,000 - 83,333 = 20% >83,333 = 30%

Hi there, I'm looking to create a supplier score card which involves weighting & sub weighting - please see example of my score card below. As you can see Logistics Ordering & Packaging have been further broken down in to sub-criteria. I took this template from a website and their way of...

Hi Guys, I'm using a custom point arrow to change the conditional formatting icon set. But cannot seem to get the right if function as well as the rule description. My conditions are: if the percentage is an increase of more than 30% - red arrow points up if the percentage is an increase of...

Hello, Whenever I have a large excel file (23mb), and I try copying any data (even one cell), excel will instantly freeze and stop working (as soon as cntrl+c is pressed). I've tried it on multiple computers, and I've tried opening it as a csv and txt file (still same problem). My computer is...