calculate

Hi I have been given a sheet of ages and asked to calculate the average. However the ages are in decimals e.g. 10.04 = 10 years and 4 months, 11.11 = 11 years and 11 months. Any ideas how to calculate an accurate average in excel?

Hello all, I am trying to create a formula in which for example, if C5<=0, show the value "N/A". Ff C5>0, then calculate the formula of C5/B5. Can anyone help? THanks! Greg

I'm trying to figure out a formula for an attendance roster that will calculate the first M/W/F of a month. Since this particular class only meets M/W/F, I'd like to generate an attendance roster that for each month (each month on separate sheet) which finds the first day of the month that's...

Hi All, I have a large workbook that has a sheet which calculates results with and without inflation. I have code that changes inflation to 0 and then back to what it was originally. Before I copy the original assumptions back I need to calculate just one sheet that is selected in a drop-down...

So, I have a list exported from a system containing unique employee ids (children). Each of these rows has the employee’s manager unique id (parent). One of the employees is the CEO and is to be considered level = 1 I would like a way to calculate per employee what level they are on in the...

Hello guys, I have 2 columns, the first one (we say A1:A100) contains 'W's, 'M's, 'L's, and some 'NA's, the second column (B1:B100) contains figures (stock returns) and also some 'NA's. what I want to do is to calculate the percent rank for each stock under 'W' group, 'M' group, and 'L' group...

I think I need to use an IF formula but can’t work it out. I have F4+E4 to give me the G4. So i have a few different hours so I need the formula so that if G4 is equal to or greater then 8 then the remainder hours calculate to multiply by 1.5 Can anyone help please?

Help Please! I am such a newbie here.. Its my first time post. I want to calculate for annualized monthly data across 12 months on excel. Column A (Monnths), B(monthly values to be annualized) and C should be annualized returns. I need an excel formula that will calculate this ... Thank you..

I have multiple UDFSs that loop through cells, I have application.volatile on them with worksheet change events that calculate the sheet. But if I am in a different sheet and press calculate, it freezes. Any suggestions?

Hi Folks, I have 3 columns wit different dates and i want to write a formula in 4th column and my condition is to calculate the aging whichever is the latest date among the three columns. Formula needs to calculate aging from =TODAY()- Latest among the 3 columns dates.

https://1drv.ms/x/s!AvjBsEPEq12ngTsi8XTPb5NMJ1_h?e=YIGtSL I wish to add the total for B and C in the Pivot Table like in cell D6. Suppose I update my PV and more data is added. How do I make it such that I can calculate the total for Company B and C and get $300? Hope that makes sense. Thanks :)

My spreadsheet looks like this: <tbody> Total Collected After Shipping & Fees Amber List Cost Estimated Profit Profit Margin $50.36 40.00 10.36 ? $13.35 10.00 3.35 ? </tbody> How do i calculate the profit margin?

<tbody> asset date purchased cost prior life current depreciation Ipad 08/5/1996 2548 1687 5 </tbody> I am using the folliowing formula...

I'm looking for a way to use VBA to calculate the IRR of the cashflows of an amortization table without actually needing an amortization table in my workbook, but rather just the loan attributes. I currently use the following function to calculate the cumulative interest paid given the...

Hello. I need to calculate the age of a work order using the start date (a2) and end date (b2). The “open” work orders will have a blank end date. I want to write a formula that will use today’s date as the end date if the end date cell is blank. I’m assuming I use an IF statement, but not...

I am trying to calculate the date in weeks by putting a number in a column A1 14/8/9 A2 6 A3 calculation of date in 6 weeks time The number in A2 could be any number of weeks Thanks

Hello Freinds, I'm working on a data were in B columns I'm having "Recharge" Or "Transfer". I'm using IF formula to calculate the Transfer commission. If " Recharge" Is there, then the commission should be "0". Can anyone help to get this formula.

See the attached files Vba is placed in a seperate file Open 1.xls file Calculate the data add all the data in column H and paste the result in K9 of vba contained file in sheet1 and close the 1.xls file Download the sample file from the below link bcoz i was unable to upload so plz have a...

I'm not able to calculate the date (accurately) I should run out of an item using the formula: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #003ecc}span.s2 {color: #005109}</style>=TODAY()+N2 where the values in...

Hi - I am trying to calculate 200000 minus a number in a cell address that changes when I insert an additional row. For example, 200,000 minus D3. (D3 is the sum of the range D1:D2) but then I insert a row and the calculation has to become 200000 minus D4 (where D4 is the sum of the range...