applicable

I have a data validation with a nested if statement. =IF(R8="D18",D18_OP,IF(R8="D24",D24_OP,IF($R$8="D34",D34_OP))) It works fine as long as I don't have D18 in R8. D18_OP named range = "Not Applicable". When D18 appears in R8 the drop down will not load with "Not Applicable" nor can I select...

Need help to get the IF statement in F89 working the way I need it to but I keep running into errors as I try to modify it. Here is the data in question: Excel 2016 (Windows) 32 bitEF81Pension without bridge$ 1,255.1482CPP$ 1,638.7983OAS$ 817.9784Average Gross Payroll (if applicable)$...

Hi, File with an examlpe - https://www.dropbox.com/s/pcn5ai8zamb0hpg/Example%201.xlsm?dl=0 It's a part of the test checking the knowledge of the training participant. When someone fills the fields and comes to the conclusion that, however, he should not answer, then set to "Not...

Hi All, I've developed a spreadsheet which is an audit document however some sections are not applicable to some sites. My issue is that because the questions are not applicable, I don't assign a score which results in a percentage score of 0%. This has a negative impact on their overall score...

Hello! I have a formula that makes a division and in some cells it shows #DIV/0! because it tries to divide by zero. That's fine, but I just want these cells to be filled with N/A (not applicable) or zero or a dash or something more pretty than #DIV/0! Any idea?

hi, Doe anyone have the solution to my issue? I would like to email the applicable workbook to out look. It will always be ( for the foreseeable future ATM) to the same recipients. 1 x to 2 x CC however, I need the subject line to contain the WC (IE 03/09/18) which will change weekly &...

hi, can some canny person send me the VBA to auto sort A2:A200 so everytime a new enter is placed within the applicable it will A-Z automatically? Many thanks in advance & for your help too. KR Trevor3007

I have range names for various range on sheet1 for eg BR1, BR2 etc that will be the same as the sheet name I need code that will copy the data from the applicable range name to the appropriate sheet using paste Special (using Paste link if possible) The comments , cells values and fill color...

I have names in Col O in Sheet2 I need the header in (O1) as well as the name in Col O to be copied to Z1 on the applicable sheet for eg BR1 on Col O as well as the heading to be copied to Sheet BR1 Z1. it would be appreciated if someone could kindly provide me with code to do this...

Hi All, I hope you're enjoying your Sunday evening. I have the following table that needs a formula inserting in the 'Status' column Table: <tbody> Unique Identifier First Name Last Name Grade Status Completed On + Years Due 12345 Jane Doe 5 Not Applicable 1 12346 John Doe 5 Not...

I have a list of criteria, 1 through, for example, which measures different aspects of a "deal", rates it simply if it is complete or completed accurately or not. The criteria list will be weighted based on importance. Not all the criteria will be applicable. so either 1, 0, or N\A with final...

Hello, I am hoping that someone may be able to point me in the right direction. I am using the Vlookup "iferror" formula as shown below =IFERROR(VLOOKUP(C7,'TABLE 1'!A2:D67,4,FALSE),IFERROR(VLOOKUP(MASTER COMPARE!C19,'TABLE 2'!A2:D21,4,FALSE),IFERROR(VLOOKUP(MASTER COMPARE!C19,TABLE...

I am working on a project that I need excel to detect the users log in and automatically select there name from a slider so it only shows data applicable from them can anyone help please

Hi, I am so confused as to why I am getting this error, and have no idea what it means. The code I am running is so, sooooo simple, so I don't understand why it is erroring out. When the code below is run (aka when something on the sheet is changed), and C5 equals 1, it does set B6 equal to...

I have source data on Sheet1 for Jul 2017 (cell K1) on a particular workbook which is imported-see sample Data Below I have July 2017 on another Workbook (K4) and would like to extract the figures for each dept pertaining to the month Applicable I would like a formula to extract the data...