## solver tool

Dears , Kindly your support to do below : When we want to weekly upgrade / downgrade capacities we must change all sources and this takes much time to …

Microsoft Excel Formulas in Excel

Dears , Kindly your support to do below : When we want to weekly upgrade / downgrade capacities we must change all sources and this takes much time to …

In one column, I have a beginning balance of $100(A1). 3 debits: $10, $20, $30 in A2, A3, A4. I want to add A2, A3, and A4 and then subtract that total from my …

HI, I have Office 3565 MSO exell 32 bit on wndows 10 pro i have sheet 1 with a listing on line 1 of my vehicle , a column for current miliage to entered …

What is the formula to calculate X=p% of Y? For example, 10=20% of what number. By: Carson

I am trying to roundup the result in CELL P8, I already have this formula in there – …

ie I need a formula that will identify cooomon words between 2 columns but with the Same Row. ie Say A1 to be Compare to B1 …

I have a list of names in two worksheets listed alphabetically but not identical. The sheets will use filters to sort afterwards. I need to use a vlookup I …

Excel 2010 I have a input cell to enter a period number – Eg 1, 2, 3 …. up to 18 I want to return sum total in output cell that totals for example …

Column a1 to a50 has a mixture of yes and no written in the cells. Column b1 to b50 has a mixture of red and blue written in the cells. What formula do I use …

In conditional formatting, I have =$A$5=”x” (Formats the target cells to Fill Green) Applies to =$B$5:$T$5 This causes cells B5 through T5 to …

=HYPERLINK(“https://cactus.nci.nih.gov/chemical/structure/”&C2&”/smiles”) does not work. the website …

If you have names displayed in various was in one cell is there a formula to correct multiple conditions. For example, one column as these variations: Oprah …

I’m looking for a formula to help me change the month of a date to a specific month of the year. Say the date is 5/6/19. I want to calculate a date the …

I have an excel file that has 243 rows with excel file names in one column. I want to pull data based on that excel document but don’t want to have …

Hi, I have a registration excel list that has names, addresses, and cells that i mark with an “x” if they have prepaid for a tshirt and another …

I have looked all over and not quite found the answer to my question. I have tried a lot of INDEX and MATCH posts which offer COUNTIF or an absolute, like 3 …

I need help with spreadsheet that I have colums with dates by formula and want to use conditional formatting to change color of cell if a manual data …

Good Day, I was wondering what formula I can use for the following scenario? Column A: I have various client numbers, but some are repeated. Column B has …

Need some help, I need to count the number of cells (in a column) that has a certain word in it based on the date in another cell (the date is formatted …

Hello! Here is my problem: Cell- A1 has a date of 3/15/1950 Cell-A2 has number of 65 Cell-A3 has a date of 1/1 (no year) Cell-A4 formula What would the formula …

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 …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.