## Question****

Dear Sir/Madam, Data, 23,45,87,31,2,3,65,50,3,45,85 Question: How to formulate the above data from left to right when the addition is more than …

Microsoft Excel Formulas in Excel

Dear Sir/Madam, Data, 23,45,87,31,2,3,65,50,3,45,85 Question: How to formulate the above data from left to right when the addition is more than …

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

Hello Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell …

I hope I can explain this correctly. I am trying to convert numbers that are less than 500 in a cell column to 500. But if a number in said cell column …

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I …

Hi, I’m currently trying to format cells in different columns so that when I select a duration option in one column, the rows in a different column are …

A learner has seven subjects, which include Home Language. Criteria to Pass: 40% in Home Language is compulsory, then at least 40% in any two other subjects …

Hi, I am trying to establish a formula to reference certain cells between two tables as the below. Sheet1 Sheet2 In Sheet1 Return …

Hello. I would like to use a conditional formula for dates, years and months while color assigning it based on what ifs. It is not working. For example …

so I have 36 stores numbered 1-36 in a column, right next to that is another column that shows a grade given to each store. I would like to pull all the stores …

I have a spreadsheet that contains thousands of addresses under these coulumn headings : address number Pre-directional Street Name Suffix I have pasted …

I would like to calculate a multi-point multiplication function and am having trouble. I am trying to do the following. IF the SUM of one column is equal …

The spreadsheet is a swimming gala recording sheet. On the first tab the times are recorded freely as 12345 (where that actually is 01:23.45) I would like this …

How can I have Excel count the cells in a given column which are each/individually less than the corespoding cells in multiple other columns? For example, …

Hello I am working on airline revenue analysis dashboard. Where i need to find the top 3 airline carriers based on total revenue generated …

I have a situation where I would like to add a formula to a staff schedue that will calculate how many Room Attendants to schedule. A Room Attendant can clean …

Assume the columns below start with column A: If you add up 23 weeks worth of 4’s, starting with column C (week 1), you will get a sum total of 92 …

I have two sheets. #1 has a mileage table with 11 locations to 11 locations with mileage from one location to another. Sheet #2 is a mileage reimbursement …

My payroll spread sheet utilizes a drop down list for employee names to be added to a work day. I use Vlookup to add the employees pay rate next to their name …

I have a spreadsheet of issues with start and close dates and would like to get an average of how long issues stay open for. Column A: Start Date Column …

if cell d5(the category) is STUDENT the price is 25. (hint: student must appear in quotes. do not enter $ for the price.) all other individual members must pay …

I’m trying to use an array formula with sumif and know the correct format is along the lines of …

Hi there I’m relatively new here in Excel, so pardon if this question might sound like an amateur. I’m trying to use COUNTIFs to calculate the …

Hi I have an excel sheet where are are telephone numbers in column A and the bill details are month wise in the following columns. For example: Number …

Using google docs excel. Hi, I was wondering if I can create a certain formula that only calculates age if the date of birth is inserted in nearby cell. …

Hello, I’m about to manage 3 different budgets in my place of work with no other method of tracking spend other than a spreadsheet. I would like …

Hi I have a drop down menu in d5 on sheet 1, this menu has the years in 2014,2015 etc, in d15 i want to know which item ive sold the most, and i want it …

T1 geo 1 T2 geo 1 T3 geo 1 T1 sam 2 T1 Nat 3 T2 Nat 3 …

UE Release Date Observation Month UE Rate Observations Days Daily UE data S&P 500 Date S&P 500 Close 5/6/55 4/1/55 4.7 5/6/55 5/6/55 37.889999 …

I am looking to know how many of these ID have used 1 or more benefits. The column C should say the total benefits used i.e. between 1-5, NOT the total count …

is there a way to automatically increment the date by 1 for each successive row with this as the original formula: =SUM(‘M:FY 2018 DepositsDeposit …

Hi I just have a question for the IF then Subtract command if possible. I have attached an example.. By:

I have list1 in excel file list1.xlsx. the first two cells are used in many other excel spreadsheets (different .xlsx files). I wasn to alter the first two …

Hello, I have a cell on one worksheet that calculates an average and displays the result as a percentage. I have that cell linked to another worksheet with a …

My problem is very small and basic but don’t know how to solve it. I have 2 cells A1 = value of Kg, B1 = Value of Manns (Kg/40). I want both the cells to …

I have 28 students in a list (numerical) who needs to sit for an examination in pairs. There are 4 different examiners. At any one time, there will be 4 …

Hi. Thanks for your help. I have a Project list. One column is the total of the project and the next is a drop down menu (the list is Designed, Tender, Quote, …

IFS function is not working in most of my client office.I have made a planning sheet using that with hardwork in my laptop(xl 2016) but in others pc it is not …

We have a pretty simple thing we are trying to do, which is to make a repair queue line. Column A = Name Column B = Estimate Time of Repair Column C = Status …