if

  1. O

    IF formula (cumulative)

    Hi I am failing to write a IF formula which will inform of impact of a bottleneck / constraint - some help would be greatly appreciated Row 7 - Before bottleneck This represents the amount of items I want to process Row 6 - Bottleneck This represent the amount of items that can be processed...
  2. R

    IF/RANK functions help (situational) included video/excel file 🥴

    Hi everyone! New user and novice excel user here trying to figure our a solution to a problem. I included a video instead of typing out the question here because it's kind of complicated with the concatenate functions that I'm using. The end-goal of what I'm trying to accomplish is based on a...
  3. N

    MATCH and INDEX help

    Can anyone assist with unpuzzling what I did wrong with this formula? I am still learning how to create MATCH and INDEX formulas. Because of the vast amount of information in the file I would prefer not sharing the cleaned file because of how long it would take to scrub it clean. If I must, I...
  4. I

    Evenly auto assign based on availability and language

    I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.
  5. S

    How to combine IF and FILTER formulas to copy text from one column to another

    I am coding qualitative data from call center agent notes, and I'm trying to adapt another researcher's Excel method. I've adapted it a bit for my own purposes, and I just can't seem to get this last piece. I'm using Excel for Mac version 16.81 So, I have all my agent notes in Column A. In...
  6. I

    If statement to return list of values based on 1 criteria

    Hi All, My issue is probably simple, but Im in a brain fog! I have 2 columns, in A, I have a list of lesson numbers, and in B a list of unique subject IDs. Example 1 1.1 1 1.2 1 1.3 2 1.4 2 1.5 3 1.6 3 1.7 1 1.8 1 1.9 2 1.10 What I want to do is return only those...
  7. S

    Changing a value when it meets a criteria from a lookup formula

    I have the following formula =LOOKUP(DATEDIF(AE4,NOW(),"Y"),{0,4;1,4;2,4;3,6;15,8}) to determine how much leave someone earns based off the years they have worked and when the person is only earning 6 hours, i need to add 4 hours to the last week of the year. How can I do this? Do I need to...
  8. N

    Sum total between bottle refill times

    Hello fellow excel enthusiasts 😊 I’m stuck trying to figure out a working formula or creating a better method to use, and was hoping that someone might be able to lend a hand, please. I have a table, detailing the amount of water that has been consumed (in ml) thought the day, marked at hourly...
  9. A

    Image with IF Condition

    Is it possible that if a specific cell is blank then the desired cell should be blank and if specific cell is not blank then the desired cell should display a picture. I am having such a situation in my result card. I wish if result card shows the "Pass" or "Fail" Status only then the next cell...
  10. M

    Return sum from one list to another list.

    List 1 has item numbers, and I want to return total sales dollars. List 2 has the item numbers across multiple locations, and I want to return the total sales dollars into column B on List 1. What formula do I need to put in B2 to return the total sum? (B2 Value should return $315, B3=$230...
  11. L

    Formula to return the value of the duplicate number

    Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return the...
  12. N

    Excel Help - If, Match Then X

    If Column A in spreadsheet 1 matches column A in spreadsheet 2, then column C in worksheet 1 equals result from Column B in spreadsheet 2. What’s this formula need to look like? Cannot figure it out. Column A in both sheets have skus. I need to match these up. Then, I need the item...
  13. D

    Timesheet Calculation

    Hi Everyone, I made this account specifically to ask this (probably very simple) question. I have gone through quite a few websites trying to get an answer but I can't seem to find one that works. Standard time is Monday through Friday 7am to 6pm Overtime is anything outside of that, so...
  14. S

    IF Function ignoring if blank

    Hi, this is probably the most basic formula but I just can't get it to work so I apologize for being slow. =IF(D3<E3,"LOSE","WIN") At present it is showing as LOSE as D3 and E3 are blank. I don't want it to show a result until the scores are input to D3 and E3. How can I do this?
  15. k3yn0t3

    Formula to Sum Based on Criteria

    Hi there. I am trying to write a formula to copy across in the highlighted neon yellow cells that checks to see if 10 different members' info matches the filter criteria at the top of the sheet. Should I add a ghost column underneath with same number of rows, and have each cell check each...
  16. H

    Hierarchical data combined into list for Google Sheets

    Good day. I have a sheet of data, columns D:G Column D is the "parent" of E, E is the parent of F and F is the parent of G. example data below: Column D Column E Column F Column G Bedroom 1 Building Internal Partitions Framework Bedroom 1 Building Internal Partitions...
  17. C

    Using ROUNDUP and IF within a cell, with a calculation already in it.

    Hi all, Hoping this one is a testing problem for the maestros on here. I have a G8, which contains the following formula =VLOOKUP($C$2,Variables!G24:H43,2,FALSE)*$G$4 This returns a result of 0.4. What I want to is within the same formula in G8, add something that checks that if the value is...
  18. T

    Combining Index, small, if, row

    Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...
  19. M

    Automatically tagging text for data analysis

    Hi everyone and thank you for reading this. I have tried to play around with IF(ISNUMBER(SEARCH... but I did not obtain exactly what I needed. Please, use the pic below as reference. Column D is the input. Column E is the output. Normally I fill in column E manually depending on what is in...
  20. J

    How to combine different percentiles with a criteria.

    I want to group different E populations together. I want to know the percentile rank of E1,E2,E3,E4. How do I combine these groups to make a percentile rank of the score? I'm doing a lot of combing populations this way, is there any way to make criteria an OR instead of an AND?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top