n/a

Hello Everyone, I'm seeking a formula that can help me with the following: Three worksheets and values on Column "A" & "D" on all worksheets exist and do not change. Columns "B" & "C" on "gw1" & "gw2" need input from user. I need a formula that can search both "gw1" & "gw2" and return a value...

Hi all, I have read many threads regarding the calculation of working hours between two dates, including the following thread https://www.mrexcel.com/forum/excel-questions/426101-calculate-only-working-hours-between-two-dates-excluding-weekends.html and the great answers from member barry...

Hello, I have the following formula on A3 = A2/A1 basically what I want my formula to read is that if we have negative with positives numbers or viceversa in cells A2 or A1 give me a N/A results, if my signs on both cells are negative or positive give the result and not N/A Thanks!

Hi all! Hopefully you can help me with an issue. Cell 1 has a value based on the result of a formula. Cell 2 has a formula based on Cell 1, but it return "N/A". If I just type the value in Cell 1, the formula works. Any ideas how I should change Cell 1 so Cell 2 shows the correct result...

How can I find the sum of the values in columns 1-3 if column A equals Yes, column B equals FC, column C equals LE? This is just a sample set, the dataset I'm using has many more columns. Thanks. <colgroup><col width="64" style="width:48pt" span="10"> </colgroup><tbody> A B C D E...

I'm making a wiring diagram/list in excel and need to find a formula for conditional formatting that will turn 2 cells red if those two cells in a given row appear anywhere else on the spreadsheet. I already have 2 formulas for (Wire Origin and Wire Origin Terminal) and (Wire Destination and...

Hey everyone! I'm working through a little but of an issue. Trying to think of a way to write a function that will cause it to check the cell to the right of it and if it has "N/A" to skip that cell and move to the cell to the right of it check that cell if it has N/A then move to the right...

Hi All! I have able to written a code where i can select which workbook i would like to use as a reference. It works fine however when the vlookup finds data i got N/A despite the exact data Here is the code LastRow = Range("B65536").End(xlUp).Row Range("AA2:AA" & LastRow).FormulaR1C1 =...

Hello - I cannot get my formula to work with a zero as the denominator for all calculations. It works for majority but not all. My criteria is as follows: A B Result 1092 329 232% 376 448 -16% 0 0 N/A...

Not sure how to do this. worksheet has the results of and audit. Y is that the ward was compliant for that question, N no, N/A and Unknown column A has the wards audited columns B-A0 have the answers to the survey Questions in the form of Y N N/A and Unknown Eg A B C Ward Was...

Hello everyone, https://imgur.com/a/0r4JGFn This is a sample spreadsheet but.. Is it possible for column Snowball to display a 1 when it meets the criteria and 0 when it doesn't? Likewise, can Douglas display a 1 when it does and a 0 when it doesn't...

Hello All, I'm trying to make this cell say nothing if there is no data in column A. In other words, I don't want the cell to say "N/A" or give me an error. The formula doesn't work and I know it's because it doesn't see any data in cell A1498. I just can't seem to figure out to make this...

Hello All, I have a working macro with vlookup function and i was able to make it work that if the cell is empty then the result cell is empty as well but if the function does not find the reference cell then it gives me N/A. Can somebody help me that instead of N/A i got blank cells as well...

Hi guys.. I have the following 3 columns in my excel sheet. The dates in column A (DateTime) are in the same format as column N(DateTime2). <tbody> DateTime (column A) DateTime2 (column N) Match VLOOKUP <colgroup><col></colgroup><tbody> 1/1/16 0:00 </tbody> 1/1/16 0:00 1 42370...

Hello, Is it possible to create a vba code that will replace data in some columns depending on the date in the file name? For instance, I have a file name "YYYY_AA_BCDE_YYYY_MM_DD_v#.#_(Mar_Final)".In the first sheet, I have a date in column O. If the file name is (Mar_Final), then if the date...

Hey guys, im having some trouble with a bar graph im making for work. I want it to be set up so that it always shows the data for the current week as well as the last 7 previous weeks (so if the data is older than that it doesnt get shown). I thought i could do this with a simple if statement...

As I was typing the title it seemed very complicated, hopefully below info will clarify it :) Each record has unique Reg# Given the data below, my formula in Destination sheet in cell B1 would return "X" if Packing Rating="Sat." otherwise return blank. Same type of Formula in Destination...

Hi all, So I'm trying to run an INDEX MATCH against the nuber of visits that some of my web pages have received and view the top 10 by category. The issue I have is that I've found that some of the pages have received the same number of visits so when running the INDEX MATCH it's returning the...

Hey all, getting N/A errors for some reason. =IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=1,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p> IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=2,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p>...

What seems simple, is driving me crazy :biggrin:. In short, cell A4 contains conditional survey responses of YES, NO, N/A and the below formula then multiplies a weighting from cell F4 to compute a raw score in the cell. My problem is when N/A is selected in the dropdown in A4, it is treating...