incomplete

Could someone please let me know if my query is correct...I keep getting a syntax error? iif(Sum([Assignment_test]![CountOfPlanNumber]+[Assignment_test]![InvComplete])=0, "Complete", "Incomplete"))) AS Expr2 FROM Assignment_test;

I just attended a session where a free ebook was mentioned on dynamic arrays. I was given an incomplete link. Can I get the link?

Hi all, I'm having trouble figuring out a formula in excel, and was hoping someone may be able to assist. I have data for a number of people and the status of their work in another column. Essentially want to calculate an overall status. If they have atleast one work complete in 2018, then...

Hi, I have a complex dashboard that uses box plots, and other statistical formulas to come up with a forecast for how many Call Volumes are coming into the suppport center. The problem I am having is the fields below point to a 9 month calendar and when we are in the current month, the volume...

GOOD AFTERNOON, I HAVE STRUGGLED ENOUGH TRYING THIS NOW ITS TIME TO ASK THE GURUS. WORKING WITH 2 COLUMNS: F WILL ONLY CONTAIN 0 OR 1 H WILL ONLY CONTAIN YES OR NO SHOULD IT BE IF AND OR? PLEASE HELP...

Hi all, I need help for this. A1 A2 A3 0 0 just Blank (if both cell contains 0) 12 12 Completed (if A1 and A2 are equal) 12 14 incomplete (if A1 and A2 is not equal) I just want output in A3 to be displayed. Thank you guys.

Hi , I have a column of address . I want to sort out the complete and incomplete address Example - Complete address ends with 4 Digit Number as this Incomplete doesnt end with 4 digits <tbody> ZETLAND NSW 2017 true YOUNG NSW 2594 true YEPPOON QLD 4703 true WOOROLOO WA 6558 true 1...

Hi there, I have a list of tasks that I want to summarise by % on how many are complete or incomplete etc. What formula is best to use? Thanks!

Hi. I would really appreciate some help with the below. Column A is the order number, B is the status of the indvidual line, C reflects B numerically with a "1" for complete and "0" for incomplete. If A1 = A2 then D is blank, if there is a difference then the completion % is displayed...

Hello all, I have a sub that works nearly perfectly, except that excel seems to lag after running. My solution to the lag was always close and reopen excel. I finally added that to the sub (using call at the very end) yet now the original sub does not run in its entirety. I'm at a loss as to...

Hello everyone, I have an issue in excel 2010 where it will not fully paste the information I'm trying to copy/paste. Sometimes less than half the data is transferred over, as if it doesn't recognize the other pieces of data. (I'm copy/pasting in between workbooks, sheets, and directly from the...

Hi All, I have a worksheet in which I have a data validation that allows values from the "names" list. Originally the "names" list was static and all was well. Then I had to make it dynamic and the data validation subsequently began to show only the first 17 names (out of ~500). When I...