40%

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...

Is there a way to stop excel from displaying a "Watermark Type" text when viewing document in page or layout view? I have a named range that appears like watermark when I view the document at less than 40% zoom. It goes away if I delete the named Range or if I view at 40% or higher zoom The...

hi I have table like the one below. I calculate grade using if() function, a for >80, b for >70 etc. The I used countif() to find out how many a,b,c, and f, I have. a = 1 b = 10 c = 3 f = 4 My question, I want excel to give me the percentage % of a, b, c, and f. so I want to have something...

Hello, I would like to format a result with currency, no dollar sign, and zero decimals. Cell H2 is the cell in question. Formula: =CONCAT(H2," (",ROUND(I2,2)*100,"%)") Result: 222000 (40%) Preferred Result: 222,000 (40%) An advanced thank you for your time and support. It is truly...

Hi there, I've had a problem where I have a row of percentages and I need to find the second occurrence of a percentage that is under 40%. E.g. if I have two rows like this <tbody> Jan Feb March April May 56% 44% 39% 25% 99% </tbody> Then I would like it to return April. I have found lots...

Hi everyone I'm trying to complete a spreadsheet for our group benefits. Our one benefit is based on a graded schedule(66.67% of the first 6000 monthly earnings, 55% of the next 3000 monthlyearnings, then 40% of the remaining earnings up to a maximum benefit of 8000per month. I have a...

Hi All. I feel like there is an easy answer to this one; I've been trying nested formulas but I can't get it right. I want to do an IF/AND statement that will produce one of 3 outcomes. This is what the final results should look like: first 2 rows are values. 3rd row is the result I want...

Hi, I have a problem and can not figure out that if there is a solution (mathematically possible) or not. I tried to demonstrate the problem below. I have tried so many things (goal seek, solver or analytical approaches) but could not find a solution. Now I am thinking that there is no solution...

Hi Guys, I need help. I want to use Icon set - 3 arrows. I want to include an arrow that indicates increase and decrease daily based on it's yesterday data. <tbody> date Cost 12/25 549.38 12/26 821.03 49.45% 12/27 300.23 -63.43% 12/28 360.00 19.91% 12/29 504.00 40.00% 12/30...

Hi, My first post here and it's got us scratching our heads. I even have an Excel guru in the office and this is one we have not seen. On a worksheet, when zoomed out further than 40%, there is a text-based graphics overlay on the worksheet. At 39% zoom or lower, it's there, at 40% or above...

Hi All I'm trying to create a comms calculation but struggling to bring to IF's together? Scenario If a salesman generates upto £ 9,999 then they get 25% of this, however if they go above £ 9,999 then they get (£9999*25%) + 40% of everything above that figure? Anyone able to help? Thanks in...