accrued

Apologies if some iteration of this question has already been asked, but I wasn't able to find an exact analogue to my situation. I'd like to create a formula that calculates compound interest on a note based on user inputs for: (i) principal, (ii) annual interest rate, (iii) interest accrual...

Hi guys, Trying to track accruals from different month's tabs in my spreadsheet to determine who has made over 99.99 and needs to be paid. In my spreadsheet, please refer to the June tab. Column N, O and P are the ones I am interested in. I am particularly keen to basically determine whether...

Hi, From the below, I need to work out the ageing of the balances. The figures in column M (highlighted yellow) are the values I'm looking to achieve, which incorporates the following: 1) The Bf balance in column C. For Project 1 this is 61 days for the £5,000. 2) The formula will understand...

Working out time. How do I use a column to calculate only if a cell contains specific criteria? e.g. Only calculate difference between start and end time if the category is "Accrued" otherwise use "0" <colgroup><col width="80" span="5" style="width:48pt"> </colgroup><tbody> Category...

I'm struggling with the below formula in Column C. I'm trying to return only the first instance of the data in Column A while maintaining the if statement to column D. <tbody> A B C D 1 GL Recon '=ROUND(IF(D4="Y",SUMIFS($B$13:$B$17,$A$13:$A$17,$A4),IF(D4="N",0)),2) 2 Invoice# Amount...

Hello there! I'm having problems coming up with an excel formula for my office. We get 10 hours and 40 minutes a month and work 8 hour days. It needs to calculate how much time accrued as well as used from the date of hire. Any help with formatting and a formula would be greatly appreciated!

I have a number of queries one of which is shown below.. When I refresh these queries they work perfect but when my co-worker tries to run the same ones they get an error that the query references other queries or steps. I have seen this error before but I don't understand why they would get...

Listed below is a dummy spreadsheet. I am trying how to get column E not to exceed 24 hours and row 27 column C (total accrued sick time) not to exceed 48. The formula is regular hours/30=accrued sick time. You cannot accrue more than 48 and cannot use more than 24 available hours per calendar...