Archive by category Excel Formulas

Microsoft Excel Formulas in Excel

Calculate age formula to only show when data is added

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

Counting Cells based on two sets of specific criteria

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 …

formula

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 …

duplication

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

Require help with an excel formula

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 …

IFS and COUNTIFS

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 …

change embedded date automatically

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 …

IF THEN SUBTRACT FORMULA

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

Communication between two independent spread sheets.

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 …

Cell not returning result with if then

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 …

Student

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 …

Random Categorisation

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 …

totals for different ‘data validation’

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 not working

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 …

Creating a Line Queue

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 …

how- Excel match record from different position of row

A B C D E F 1 Date Batch 1 1st Time batch 2 2nd Time Hour 2 28/1/19 AA103   BB100 6:09am 0.75hrs 3 28/1/19 AA104   BB101 6:15am 1.23hrs 4 …

Extract Specific Text

Key Word   Store Name   Key Word Result Pharmacy   all in all grocery     Grocery   health pharmacy 2365     …

How do I get a result to display “0” for no credit given?

Hello…My name is Robert, and I am an intermediate school math teacher. The following formula works for me, but I also need to a assign a value of zero …

Average a column of numbers

How do I set up a column to average a row of numbers? Example: Number Average 120 120 125 123 200 148   I want to make the cells in the …

Calculating Rental Period

Hi all,    I need to calculate the rental period for a widget between a start date and an end date. This rental period has to be broken down as …

How to identify similar (not duplicate) text within same column

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

Mapping Excel data

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

excel formula

what is the formula for a 10% discount up to \$4000, with a maximum discount of \$400.  Thanks. By:

Dumping Formulas

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them.  Rather than transcribe each cell’s formula, is there a way …

Dumping Formulas

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them.  Rather than transcribe each cell’s formula, is there a way …

Dumping Formulas

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them.  Rather than transcribe each cell’s formula, is there a way …

Engineer

Hi, I am looking for some support regarding the below issue.    A B C D Lead Time Example Wk 36 2019 Wk 50  2020 19 If (CD + Lead Time is less …

Solution for following problem:

Suggest a formula for the below problem:   Consider Sheet 2 of the attached file: As you can see two cells i.e. H17 & I17 are highlighted. When two …

Data Formula

Hi there, I am using excel and need some assistance. I have 2 columns of data. The first column is a list of countries and the second column is a list of …

Formula for tiered billing

Hey there!  I’m new here and having trouble setting up a formula that will return a value based on a tiered billing.    Example: A1 …

Need help with index/match (possibly) related formula

Hi ,   Thanks in advance for your time.   I am trying to figure out a formula to help me return data fields that match information in columns. …

Is it possible to enter a number in one cell and have a different cell populate with a set value corresponding with the number?

How can I make it so that when I input a number into Worksheet 1, cell B1(#household members), B2 updates with the corresponding number …

Formula question

I wanted to create a formula that can detect if the value’s decimal in the cell is over .60 and if true then to subtract 0.4.   So I have 38922.64 …

3 matching cells

Can anybody suggest a way to check whether any three consecutive cells in a column are equal? Anywhere in the column, but there must be three identical values …

if formula

Hi hope you can help Is there a formula where I can get  column D to equal column C, if column A is equal or < 0.01 or > 0.01       A …

Project Number Generator

Dear Spreadsheet warriors i’m trying to create a project number generator using excel by choosing from a selection as per the spreadsheet provided …

Formula Question

I have tried searching and cannot find what I need. I currently have 5 worksheets within my workbook. They are all the same worksheet just named …

Formul Question

I wrote the following formula and it works for 11 of the 12 months.  I cannot get it to work for January. It is written the same way except for the last …

Number of overlapping times

I have a set of rows with a start time and end time each.  Each row represents the duration for usage of a resource.  What I need to understand is …