## Formula / Equation help

Hello, I am trying to replicate the formula below in excel, but can’t quite get it right. The aim is to use the formula to help drive data …

Hello, I am trying to replicate the formula below in excel, but can’t quite get it right. The aim is to use the formula to help drive data …

Hello, 2 I have a sheet that contains leaves applied by employees.This sheet has leaves applied for atleast last 4 months. …

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …

Hi, I would like to compare the ‘lookup value’ against the list of 5 values and find out the ‘first value’ that is equal to or greater …

I have stumbled across a small issue which I can’t seem to overcome. In column A, I have a list of amounts for example Column A 234.34 2286.59 100.00 1286.48 …

Hello, I am attempting to build a formula where column M would fill based on the imput in column L and change based on a value entered in Column K. I …

Hello, I am looking to create a report that pulls data from specific section on another report. The report i want to make will have a new days worth of …

I’m tryint to fiure out a formula for a spreadsheet. I need the formula to add the number purchased in e2 to be multiplied to the $ value in …

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

I’m trying to create a report on excel that produces a red light, yellow light, or green light (all pictures) based on if an inputted number is lower, …

How do I create a formula for the following: IF cell A is >=5,000,000 give me 5,000,000, if no, give me 3% Trying to figure out the lesser of 5,000,000 or …

Good afternoon, I have a question about a project that I am reviewing. I would like to know how to use a simple “3-D” formula for …

Hello, I’m basically wanting to drag data from a worksheet containing thousands of cells worth of data into a template I have created. I …

Not sure what type of formula I need but I will try my best to describe the situation. On a risk matrix there are 6 levels of severity (numbered 1-6) and 6 …

Hi everyone, I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times. Mon – Fri: 17:00 – …

In cell G22, type in Rent or Buy. (either word) In cell B10, create a formula that will display the total facility expenses depending on whether the club …

Hey guys, I hope someone can help me with this. I’m trying to create a timetable to monitor my hours and what shift brackets they fall into but …

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

I have a list of work that has a date received column and a two week deadline date column next to each other. I then have a date completed column which …

Hello, I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …

Hi Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria …

Hi Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria …

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png Like you can see there …

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I …

If i have 2 different sheets with 10 headers (eg “Coustomer name” “invoice number” and “insurance name” etc). I was to copy …

Hello this may be a long shot but I need some assistance with data validation. We are currently using a new tool to automate firewall requests in our network …

Can anyone help ? i Just want this … Code Name Quantity 111 A 5 112 B 6 117 G 1 113 C 4 114 D 2 111 A 5 115 E 3 114 D 2 116 F 2 117 G 3 … to this …

If I wanted to fill a certain number of cells according to a number. How would i do this? For example cell, B1 is 5 And I create a box then I say that I …

Hi, I am trying to analyze my accounts easily and I would like to locate a specific item from one column and the amount spent on that item from the next …

Hello! I am working on a delivery schedule. I want to match it with the delivery history to find the previous cost. What I would like is a formula that matches …

Suppose in sheet1 :: mango in A1, egg in B1, fish in C1. All these in row 1 Now in sheet2 ::: D5 contain formula =sheet1!A1, A7 contain formula …

Hi, I have a unique values in column A and related times for each of the unique value in column B. The times recorded for the unique values may vary …

I have a spread sheet which currently has 600 rows and 225 colomns… I have 10 main columns for detail sorting and then 215 for different Job codes I have …

Hi guys. So I’m going to try to explain this as well as I can, but might fail. I have three columns, let’s day A, B, and C. So I tried to kind of …

Hello – I have a spreadsheet of data (Excel 2016) analyzing newsletter results for our firm. Column A has client email addresses and each …

Hello Team, Please help me to solve below; Q. Conditional formatting to highlight numbers 20% above overall average and 20% below overall average in given …

I’m having the hardest time getting excel 2013 to get all the things I need rolled into one. I need to enter times in military time and know the …

Hello, I am a beginner in excel. I need some help on data validation formula. Due to character limitation, I am not able to add two more IF clause …

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.