functions /formulas

Not sure if this is possible - but wanted to ask. Need to calculate a "Year-to-date" balance of a savings account while using the TODAY() function as the start date (so it dynamically changes). Ex: Total Goal Amt: 5000 End Date: Dec 2026 Total # of Months till completion: 24 (*calculated...

Can someone help me please. As you can see in cells B17 and C17 I have a size with a ± value of 0.30 and column D is for the lowest size(110.50 - 0.30) and Column E is for the highest size(110.50 + 0.30). The formula that I am using works perfectly but that is only if there is ± but sometimes...

Hello guys, I am attempting to calculate the length and qty of horizontal lines on a triangle that are a set distance apart from the bottom. (Wall battens in the gable of a shed) I can use this formula =((Ridge-Eave)-Spacing)/TAN(RADIANS(AngleOfRoof)) but then i need to duplicate that formula...

Is there a code or formula I can put in place that will enter the Microsoft user's name or email, who is in the excel sheet, in column N when text is entered in column A?

Okay, I am beginner/intermediate Excel user for work. Working with Excel 2010. I have a thought process in my head for what I want to happen, but cannot figure out how to execute it. I am tracking employee attendance over a 12 month rolling calendar. Here is my spreadsheet; Basically I have...

I have been trying to count a column of data based on specific criteria. Here is an image of my data: The data in column A is actually in an external workbook (for simplicity I am showing it all in one image here) and I am using the SUMPRODUCT function to try to count how many times any time...

Hello, I'm relatively new to macros, and need to run one that runs a loop that sums anything in 2017 in each worksheet. There are about 20 worksheets that all set up like this; Payment date Beginning Balance Monthly Payment Interest...

Hello All, I'm working on a conditional format formula and have the first part figured out but stuck on the second part. I need conditional formatting that says, =IF(NOT($B2=0),(AND($C2<B$4,$D2>$C2))) is true then add 1 month to the Due date (column E) and highlight that calculated month...

Hi Guys. I am trying to make a fantasy football team selector that will look at the list of my players and pick the best option for the position i want to pick and i am wondering if you guys could help. I have a sheet (named squadsheet) with all my player's ratings in each and every position...

Hello, guys, I'm currently having the final assignment of my semester and I'm having difficulty when it comes to the part to adding up dashes as zeros. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Thursday Friday Saturday TOTAL Park Ticket Type Park Ticket Type Park...

I want to calculate the attrition rate in the following data set <colgroup><col span="2"><col><col><col></colgroup><tbody> effective_date hire_date UNIQUE_ID emp_id full_name 30-04-16 29-11-10 703621Peter Jones 703621 Peter Jones 31-07-16 29-11-10 703621Peter Jones 703621 Peter Jones...

Hello, I am trying to figure out a way to get a count if certain criteria's are met including an AND function. Is this possible? Example: I am trying to get a count if Column B & C both do not equal "0", Column A equals "GC", and Column D equals "Active". Is this possible? I currently tried...

Hi, I have a problem where I need to add an extra function to a formula. I currently have the following table on a worksheet:- <tbody> A B C D E F 18 Log Cabin Quantity Size Notes Twin Skin Insulate Floor 19 Cowbeech 1 3x3 1 1 20 Brightling 21...

Hello all, and thank you for whatever help you can provide. I am using excel to look at historical financial data. I have used a query to pull and update historical stock data from Yahoo Finance. I need to lookup the cell with the lowest value, return that value and the date of that value to...

Link <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><bdo dir="ltr">=INDEX(Student,MATCH("Teacher 2",Teacher,0)) <bdo dir="ltr">=IF($A$2=INDEX(Student,MATCH("Teacher 2",Teacher,0)),OFFSET(INDEX(Student,MATCH("Teacher...

Hello! I work for a non-profit organization that helps special children. I have to make a table that contains children's age (among other information). I don't know how to explain what I want to do, so I will write an example: Name Age John Smith 5 John Smith 13 John Smith...

Is there a way to move a range of cells down for eg. Say I have a value in cell d8 and I need cell c8. To c whatever to move down with there content included