1. C

    If statement to give a 'yes' or 'no' if a time fall between a range

    Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris
  2. D

    Check if a value exists in 2 columns and return true/false

    I'm trying to make a formula that checks if a code exists in 2 existent columns, if it exists in BOTH, it returns a text, that part works perfectly, I used If, And, Match for it. But when i tried to get the other half, when it exists in only one of both (X-Or) it returns error, because of the...
  3. K

    IF with Unless conditions?

    Hi, Hoping I can get some assistance on this. So I'm pretty much a novice excel user when it comes to formulas and logics; but I am trying to somewhat automate a commission report we use with a few different formulas for requirements. There are a few conditions that need to be met and different...
  4. M

    Use Conditional Formatting to to Highlight Cells with Specific text and IF formula condition

    I have 3 cells that I am looking at: Contact Name Name Word Count Name Fix John John Doe 3 John Doe Bear Bear Joe 3 Bear Joe What I need is to run Conditional Formatting formula to highlight the CONTACT NAME column if the number in the NAME WORD COUNT column is equal to 3 and if the...
  5. M

    Extracting Data based om Condition

    Hello all, i want to extract data from column A to column B using formula. If number of characters after the hyphen is less than or equal to 4 then it has to be copied to respective B column cell. Refer example. Thank you. AB1HeadingExtracted...
  6. W

    Need to add a IF Statement to another IF Statement.

    Greetings, I have my Blood Sugar Log that I need to add an IF Statement to a cell that has 2 IF Statements. =IF(K23="","",IFERROR(RIGHT(SUBSTITUTE(TRIM(LEFT(SUBSTITUTE($V$11,"Morning",REPT(" ",255),1),255))," ",REPT(" ",255)),99)+0,"")) I need to check back a day at lunchtime to see if I was...
  7. M

    If statement....

    So I have a list if things in a sheet. In the A column there are names, B column has a date, C column has a number and the D column has another date which is 5 days from the date in column B. I want to be able to come up with something that when someone's name is written into column A and if the...
  8. T

    If formula question.

    Hi guys, I need some explaining in IF formula. How can I write condition with IF to automate check my Data Base from my table automatically? something like this: =IF( E3=F3 then past value from G3 in C3 cell) + =If( I already have value in C3 cell but it is not the same as in G3 then change it...
  9. A

    Help in correcting/reworking this general IF+INDEX/MATCH(?) Formula

    Good Day, Good People I'm having some troubles writing the proper formula for my data Basically, I'll fetch the data from one sheet (RAW) to another main work area (IIIE), but there's some error Here's my goal: First, check if the corresponding value on RAW is greater than 0 (if not, print the...
  10. L

    How to IF multiple options

    Hi, I have a problem where I have price data from one company and want to allign it to our products. Basically saying, if product A falls under these measurements it is in group 1. If Product A is in group 1 and has a weight of 1 KG the price is 1,00 but if the product is 2 KG the price is...
  11. E

    Excel Macro to pop-up message based on if and multiplication

    Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...
  12. R

    Problem with IF statement when using the get application.getfilename()

    Hey everyone! i need some help with my vba, heres my code: "Public Sub importTextFile() Dim textfile As Workbook 'Set textfile = Workbooks.Open("") Dim openFiles As Variant Dim i As Integer openFiles = getFiles() If openFiles = False Then...
  13. U

    Swap values in the rows and column based on given value that are extracted from a parent child data sheet

    I have a Excel table in the form below that was extracted from a separate sheet: Level1 Level1-Level2 Level2 Level2-Level3 Level3 Level3-Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild...
  14. U

    Want to fill and swap values in the cells and column

    I have a excel table in the form below: Level1 Level1- Level2 Level2 Level2- Level3 Level3 Level3- Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on... Level1-Level2 is...
  15. B

    Complex IF formula

    Hi everyone, I hope I can explain in detail, what I need. Cell J12 reflects the required date of drawing 101 for PO 123456. For this I used the formula: =IF(ISBLANK($B12),"",$B12+14) Cell J13 needs to reflect the required date of drawing 102, based on the date drawing 101 was sent back to the...
  16. O

    Look up a table, check availability then create a drop down list.

    Hi Everyone, I have some tables that show information and availability of products. e.g., List of colours then columns that show what finishes they are available in. (Pic 01) Firstly I am not sure if I am doing this in the best practice, but this is what I have so far. I then have another table...
  17. S

    an easier way??!!

    I am looking for an easy, more streamlined way to search if a time is between to times in different cells, and return a value if it falls into the range. It is GIS data with thousands of lines that I am trying to interpret for a new project and I feel there must be a way. I think I could do as...
  18. R

    Small business owner needs help with excel formula

    For context: Right now I am a small business owner who uses quickbooks. my customers are set up with monthly payment plans that I manually keep track of. my business has grown so it’s hard to keep track of all these customers at this point. SO the columns I have are: customer name, Amount...
  19. I

    Array in If statement

    I have above sample data. In cells F9 and F10 I want to sum 'Sales' (C5:C10) for the respective months (Jan, Feb) based on the user input in cell F3. With following formula I can get the sum of sales for an individual product per month: =SUMIFS(C5:C10,B5:B10,E9,A5:A10,F3). To get the sum of...
  20. M

    Vlookup to return date from data sheet if between certain date range.

    Hello all, I have a two sheet workspace. Sheet 1 is called Data and sheet 2 is Print Dates. In Sheet 1 I have in multiple columns three sites. Site 1, 2 and 3. Site reference is found in row 3. Columns A4:A80 are dates for Site 1, Columns C4:C80 are dates for Site 2 and Columns E4:E80 are...

This Week's Hot Topics

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