# Archive by category Excel Formulas

Microsoft Excel Formulas in Excel

## Formula to Extract Text from Cell

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …

## Formula Help

Hi   I have a spreadsheet with factory name, review date and overall evluation. Some factories may have multiple entires and reviews. I would like the …

## Tracking value changes to a number

I am trying to figure out what formula I would use to track value changes to my Blank Permits. For example, I have an Export Permit # 05064578 with several …

## Multiple LOOKUP criteria

Is it possible to have multiple criteria in a LOOKUP formula?  By: hands in

## excel

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

## Data in consecutive cells

I want to room students for specific exams. I would like to input a formula or something to allow 24 cells to be populated with the same room number. Is this …

## Mr

Help with excel formula nested IF statement in simpe spreadsheet using Excel 2016 with Windows 10.   Hi, I am trying to include a nested formula in a …

## Mr

Hi, I am trying to include a nested formula in a spread sheet. the formula is =IF(\$G22=”S”,\$E22-205,””,IF(\$G22=2,E22)) G22 is either S …

## Min and Max function wrong results

I cannot work out what I am doing wrong. I want to return the highest value if any of the two values in two cells is above 155, otherwise return the lowest …

## Keep Cell Constant, but change after Number

Hi Guys,   I would like to keep a value constant for the first cell link in this and then change it to the next 4 automatically from \$2 to \$3. Then after …

## Conditional format cells only that contain a sequence of blanks

Hi all, I need some help trying to nut out a conditional formating formula. I need to only highlight cells that contain 3 or more blanks in sequence in a row …

## corrected the formula in excel

1 F   2 H   2 F   3 H   4 F   5 H                             …

## Engineer

Sir, I need to create Preventive maintenance plan scheduled for equipment. We will do service for every 250 hours for the equipment. For A-check (250 hrs), …

## Excel conditional question

Hi my question is, i have to do a shipping simulation, based on the stock i have. if i have more than 1000 pieces i would ship my product by sea and when …

## Most common text

I need a formula to compare the text (test will be one of the following: FREQ, PROB, OCC, REM, IMP, INC) in every third column of row 42 (i.e starting at C42, …

## JimCin91

I have 2 times say 2:39PM and 5:24PM i can already change the total difference in time to total mins. but in the same formula i need to show that if the total …

## Mr

Good day Worksheet “Summary” contains information of employees i.e: employee number, name, id, time worked, pay rate, pay etc. Worksheet …

## im dont know if this is an if equation

cell d26 that formula should be as followed =(C20+C21-B26-B27-C34-E48)*(12%)+74.6…… The end of that formula is where im having my problem …

## Formula changing when sorted

Hi all,   I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working. How do I …

## 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 …

## formula

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 …

## OR and MAX

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 …

## X=p% of Y

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

## IF and ROUNDUP in same formula

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

## Similar Words in two Columns alligned per wor

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       …

## Vlookup help

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 …

## Sum total on row that increments by 2 columns when increasing input cell by 1

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 …

## Help with formula

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 …

## Conditional Formatting Throughout

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 …

## Name Column Correction

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 …

## EXCEL date formula help

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 …

## Replace text in a hyperlink based on infromation in another cell

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 …

## Formulas

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 …

## INDEX MATCH formula for multiple criteria

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 …

## conditional formatting

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 …