if formula

Hi. I have zero knowledge of excel VBA. I am working on a project. From a seperate program i am able to export reports into an excel spreadsheet. I want to copy and paste the spreadsheet into another excel workbook that has a Macro waiting to be used. The report results are always the same...

Hello all, I have a formula that works fine as it is now, but my company went and changed the criteria so I need to add more levels to this formula. Basically, in Cell M1 is the hire date and Cell M2 is the status which is always Part Time or Full Time. Right now the formula uses the date as a...

Working on metadata for a music library. I'm having problems with an IF formula, there are five possible outcomes for the cell named "Tempo": Unspecified Very Fast (131+BPM) Fast (111-130BPM) Medium (90-110 BPM) Slow (0-89 BPM) In my formula, S2 is the BPM value of each song =IF(S2<90,"Slow...

I have a criteria I need to add to both true and false sides of an existing IF formula. I want to add IF(N1="ZINC",REF!A6&REF!A4) When I try, it's unhappy with how I do it so evidently I haven't learned how to do it right yet. Basically, if N1 has Zinc appear in it, _Z needs to be added...

I want to insert nothing if date is less than today otherwise a single space. I've tried if(B2>today(),""," ") and if(B2=today()-1,""," ") but not working. Please check https://docs.google.com/spreadsheets/d/1NbwmB_Vtgkcb7x8NyjpUIlzR-oIANyBSHjVbcOv5t-I/edit#gid=2114046438

Hi, I am looking to produce a sheet that follows the logic of: 1. select a value from a drop down list 2. auto populate/lookup a table based on the value selected from 1. - so if value from 1. was "Yes" the sheet would present(hide/unhide) a table from cells A1:D12. and if the value was...

Hello all, I am having difficulties with matching information from two columns and returning information from a third column. Example: Column A has 50 rows each with a value Column B has 30 Rows each with a corresponding value Column C has 30 Rows each with a value I need a formula that...

Hello! I'm trying to write two different formulas that show the following: Typing in Cell B1...If Cell A1 contains "Apple" AND "Orange", but also DOES NOT contain "Banana" OR "Grape" OR "Pear", then return the value in cell D1, otherwise, return a blank. Typing in Cell C1...If Cell A1...

Hi! I'm new to VBA and need help. I have a column on one worksheet titled "Profit" that has various numbers listed in column C that correspond with the accounts in column A. On another worksheet titled "Total" I have a cell that I need to filter by. I'm trying to come up with an "If" statement...

Here is my worksheet example. I need a formula to count how many times the 'Service Level %' was greater than 79.999% for each day of the week. So for Monday, there is two data points, but, 1 would be my answer in this example. <tbody> Weekday Service Level % Calls Offered Work days Mon 81%...

Hi all, I just want to perform a quick quality check on some of my data and I am after a bit of help to make the proper formula as I keep getting too fewer arguments with my formula. <tbody> A B C 1 Food Code Food Matches? 2 MARTOA Marmite Yes 3 JAMTOA Jam Yes 4 HONTOA Marmite No 5...

Hello Excel God's and Goddesses - Here again asking for some help, this Time with Conditional formatting Cell A1 contains a dollar amount and cell B1 contains a % number from 0-100% What I'm looking to do is apply conditional formatting to cell A1 based on the value of cell B1 as follows If...

Hi, I am creating a database for my office that auto fills most of the information when entering a particular code that corresponds to a customer. IE the first 4 digits in a cell entry would be the customer code and the other 4 would be the job reference (1465-0045). A separate cell with multi...

I have the following code but the IF, ElseIf, ElseIf doesn't work and I want to get away from the Activate command but it keeps erroring with everything I've tried, possibily due to the Dir function. Sub DataPull() Dim Path, Name, Trend As String Dim pos, FDate, M, Y, D As Integer Dim wb, As...

Team, Working on a spread sheet that is calculating the expected return date by number of pages and date turned in. Current formula: =IF(I3<=0,"",IF(I3=5,"2"+B3,IF(I3<50,"3"+B3,IF(I3>=50,"14"+B3)))) Formula breakdown IF(I3<=0 (Zero pages to keep the "FALSE" from appearing) IF(I3=5 (5...

See formula below, and what I am trying to accomplish: =IF((D53>=1<=5),D53*0.5,IF((D53>=6<=44),D53*0.42,IF((D53>=45<=66),D53*0.4,IF((D53>=67<=132),D53*0.36,IF((D53>=133<=400),D53*0.3, IF((D53>400), Quote)))))) I am trying to create a formula to help calculate charges... essentially, what I...

I am looking for a formula so that if a a date is a holiday or weekend, it will subtract days until it reaches a non-weekend or non-holiday but if it's not a weekend or holiday to keep the original date. Can someone help me with this please?

Hello, thanks for any help you might be able to give me. My knowledge of formulas is limited so apologies if I'm not very clear. Our supplier is split into 4 divisions, with each division having multiple short codes for each branch - see below for an example (there can be 30+ short codes...

Hi, I'm hoping this is a relatively straight forward query for my first post on this forum. I have 2 worksheets which I'll call 'Sheet 1' and 'Sheet 2'. Both contain values in Column A and Column B, with an additional description Column C on Sheet 2. Sheet 2 contains raw data which acts as a...

Hi there, I am trying to create a new column in my dataset that will display a "yes" if ANY of the three criteria are met and a "no" if none of the criteria are met. For example if someone participated in year 1 and scored a 2 or above OR participated in year 2 and scored a 2.5 or above OR...