## Returning project status based on dates in multiple cells using a nested IF function

Hi, I am trying to create a cell that shows whether a project is on track, late or ahead of schedule using multiple dates derived from multiple tasks within …

Hi, I am trying to create a cell that shows whether a project is on track, late or ahead of schedule using multiple dates derived from multiple tasks within …

Hello there! I need help with the VLOOKUP formula, can anyone help out? Many thanx in advance! I can upload a file, so it will make it clearer. Emanuela …

I have multiple columns of info that I need condensed into just one column. However, I also need that one final column to mention the info only once. In other …

Hi I have 2 sets of data. I want to tally the amount of times one is greater than the other. For example …

IF I HAVE TWO SPREADSHEETS AND I WANT TO FIND WHERE: IF VALUE IN “SPREADSHEET 1” COLUMN A MATCHES A VALUE IN COLUMN A IN …

I have a spreadsheet with columns representing the months of the year. What I need is formatting to change the color of the font after the end of that …

Hi, I have the following formula: …

i have 3 shifts A shift is from=6:00-15:00 B shift is from=13:00-22:00 C shift is from=21:00-6:00 excel should automatically …

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula: …

I am struggling to create a conditional format formula that highlights the following; – Highlight any rows of the cells within Column B …

I have a list of 20 checks. I am looking for 8 that equal $1128.25. Is there a formula applied to the 20 to find which 8 give me my total? Thank you for your …

I am trying to create a formula which will find all of the students in a particular program by subject code. My formula works if there is just one …

Could someone break this formula piece by piece and explain how it works to me? it works appropriately in my file, but I am unsure how exactly it works. …

find the bonus.if sales greater than or equal to 500000,bonus is 0.5% on sales, otherwise enter zero. By: OSHADHI DE

Hi, Please I want to know the formula if the rersponse received within 12 calnder days to give check mark And if more that 12 calender days to give X as …

Hello, i know there must be a simple solution to this but cant figure it out atm. I have a table that i added to data model and then take out graphs from. The …

How do i Express the following multiple conditions in 1 formula IF A1=10 and B1=15 then C1=Apple Else C1= Orange IF A1=20 and B1=25 then C1=Tomato Else C1= …

Hi Everyone, I have two drop down one will have the values of all month that is from January to December other one is dependent dropdown will have values of …

An API returned the following result: { “Global Quote”: { “01. …

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook. I’m getting an error in my code on the last line …

I want to have the date auto fill in column G when the word “Complete” is in column F and want it to stay that date. How do i do that or can that …

I am trying to create a spreadsheet that will total the number of hours spent in work during each month and give me the monthly average based on the number of …

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

Hello: I am trying to create a formula that will search two columns of data. Each column is on a separate sheet within the same workbook. If …

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’ve got 2 sheets with common column A. If the cells in column A of sheet 2 match that in sheet 1, I want to copy the data from sheet 2 columns B-J …

I need a formula to count distinct IDs based on category and the date the category was added is less than 30 days Data structure: Column F – …

Current formula i am using: …

A company works out the monthly pay for sales staff using the equation y = ___x 10 + 600, where y is the monthly wage (£) and x is the …

applied a formula in a cell and the result is 0.2. Used this value in another cell in Index & match formula but the formula is taking 0.2 as …

i have about 1000 emails Ids in word. i have copied from word to Doc. and all emails copied to 1 row example: abc@gmail.com abc@hotmail.com …

I need to know when various symbols can appear in Excel (Conditional Formatting) Formulas, and when a letter character followed by a number character can …

I need a formula to look if a value from a cell exist in a array of data and print “name 1” if it was found, if not search another array, if found …

Hi, Lets say that I can export from a system this set of data: Student Number Student Name Class Fruit Quantity 1234 Tom 2A Orange 0 …

what will be the formula for calculating if an employees work from 09:00 am to 07:00pm per day will be paid rs750/-, and after 07:00pm until 06:00 am will be …

Sheet 1 A B 1 Apple 10 2 Pear 8 3 Orange 3 Sheet 2 A B 1 Apple 7 2 Orange 3 3 Durain 1 Sheet 3 A B 1 Orange 4 2 Pear 6 3 Banana 5 Sheet 4 …

Hello, I’m a learning to trade the stock market. There is a rule called Pattern Day Trading (PDT). This rule says in a rolling 5 day period …

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.