if formula

Hi, I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve; Car Type B14:B23 Tax Treatment E14:E23 Private % F14:F23 Input Data B28:B37 I would like the Input Data B28:B37 to be pre-populated depending on what the Tax...

Hi there, I have 3x Form Check Boxes. If any of them are ticked, I would like sheet "Dairy" to be visible. If none of them are ticked, sheet "Dairy" should be hidden. I have linked the 3x check box references to cells P1, P2 and P3. In P4 I have the following formula...

hi, so the workbook is set up like this, with 4 columns: Column A - country code Column B - country name for that code and then you have the same, but not in the same order Column C - country code Column D - country name i need a formula looks at the country code in C2. If C2 is present in...

Hello, I am at a loss as to what is happening here. I have some survey data on one sheet, and I am putting together a summary on another sheet. I want mean, standard deviation of the sample, and median for some of the data. I am compiling the summary statistics both for all surveys and for...

Hi All, Good morning/afternoon/evening depending on where you are in the world. I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and...

Hi there, I would like cell D310 to return blank, if cell B310 is blank. Both contain an if formula.. Cell B310 =IF(SUM(F310:G310)<>0,433,"") Cell D310 =IF(N(B310)<>"",FYE_Date,"") In this instance, both cells should be blank but cell D310 is returning the FYE Date. Does anyone have any...

Hi there, I have a basic formula =IF(D181=B268,B181,) This correctly returns "Dairy Foods" However, when I try to extend the range =IF(D181:D182=B268,B181:B182,) It returns #VALUE !, instead of "Dairy Foods". Does anyone know why it's going that? Thank you!

<tbody> A B C D E 1 Job Number Date Amount Week 1 Week 2 2 02/03/2019 09/03/2019 3 08/03/2019 15/03/2019 4 201 05/03/2019 3182.20 5 201 05/03/2019 2137.80 6 201 07/03/2019 4349.80 7 201 08/03/2019 2362.80 8 201 11/03/2019...

Hi, I am trying to determine if I am using the correct type of formula and figure out why I am getting an error with the formula I am using (maybe I should use a different formula completely.. such as an index or some sort of array or a if... IDK). I need to search column C row 1:556, on...

I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore...

Ok two I have two files File 1 Column A Column B Currency FX Rate USD 1.14 EUR 1 JPY 126.77 File 2 Column F Column G Column K Local Currency Local...

Hi there, i was hoping someone could help me with this query. i have a large set of address data which needs to be cleansed and analysed to find duplication within rows. i have included a sample set of data which hopefully will portray my issues. Hopefully, someone can help. <tbody> Name...

Hello all - I am trying to figure out a way to do the following please, and could use some help: I have the following headers: A1 = TestA, B1= TestA Verified, C1= TestB, D1 = TestB Verified, E1= Time, F1= Time Verified, and finally G1 = All Tests Satisfied, I have a lookup that populates the...

Hello! I am trying to use a DATEDIF formula to calculate a number that is then used to in an IF formula to generate a score. The issues is that for some of the DATEDIF calculations the EndDate is before the StartDate. When this happens, I have the formula generate a "0". I then use the...

Hello, I need help with a complex (to me) IF statement. Here is the link to the sheet I am working on: https://docs.google.com/spreadsheets/d/1RbJJknpUzxzi4eGcju7nD0N_X9wfb69uCpunZQxayC4/edit?usp=sharing What I need is on Friday Poles A13 - I need a formula to check Friday Poles D13:F13...

Hello, I am trying to change the values in my Status column to either Overdue, On Track, or Blank. These will reference my Due Date column. I have figured out how to have my cell = Overdue or On Track, but am having difficulty adding an additional layer to the formula. Currently, I have...

I have this very very big list of almost 700K rows and about 30 columns of data. I have a somewhat working formula to do what I want but it doesn't really work 100% of the time. The data is of all purchases done during a set period and I have a formula that determines what type of purchase it...

Good morning all, i am looking for some assistance if at all possible. I have a spreadsheet with a list of dates (all Mondays) that represent weeks within a large work planner I am developing. I am looking for an IF formula that will let me know if “today()” is within a certain week i.e. if...

Hi All, Below is the data: I am trying formula, but giving error...

<tbody> Cost center Dept Account Desc Budget Actual $ Var % var 712 Acctg Revenue 10 1 -9 90% 712 Acctg Salaries 5 8 -3 60% 712 Acctg Total 5 -7 -12 240% 814 HR Revenue 10 10 0 0 814 HR Salaries 11 11 0 0 814 HR Total -1 -1 0 0 </tbody> Let's say I have the above table...