null

Here is a formula I am trying to build that basically states: If the current month value is (null) and the next month value is (null) then say "OKAY", but if the current month value is (null) and the second month value is <>(null) say "Current Month NA?" and if all of that is false (current...

Can someone help me figure out why this if statement isn't working properly? The expectation is that if any of the first 5 fields are not null AND one of the first 4 fields are null, it should throw an error. (It is ok for the first 4 fields to be not null, and the 5th field to be null)...

Each day I enter my weight in a cell running across the sheet Sunday - Monday 7 cells D3 - J3. I want to have the 8th cell K3 tell me each day how much I have loss since Sunday D3?

I have quantities in cell D3 thru J3. D3 cell has the count of items at the beginning of the week. Each day the new inventory count is in the next cell. I want to be able to total at the end of each day how many items were sold?

Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...

Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...

HI, I HAVE DATA INPUTS IN CELLS A1 TO A5. I WANT VALUES IN "INPUT CELL "TO CHANGE BASED ON UNIT SYSTEM (METRIC SYSTEM OR BRITISH SYSTEM) IF SELECTED AT FIRST. it is important to consider that that values in CELL A1 TO A5 ARE "INPUTS" FOR EXAMPLE...

I have a data set and I am trying to simply add to columns together, both columns are decimal type. Some of the values are null in one column or the other and no matter what I have tried the sum always returns a null value in the calculated column for those rows with null values in one...

Whether I convert a number to "text" format, or use the apostrophe to indicate a text string that consists of numbers, I can still perform calculations on those strings. Why is that? Even crazier, I changed the number converted to "text" format to a string of letters, and my IF function still...

Hello I’m new to this and hope you may be able to help. I regularly get two columns of figures which I want to import into columns B and C in a worksheet. The goal is to end up with both columns the same. I therefore need to identify the differences between the columns. The problem is that...

Hello, Hope you are well. I have written code that does calculations with values in textboxes depending on If they are null or not. But for some reason I get a Type mismatch error despite the Not Null If statement being true. Example: If textbox 6 and 1 is empty and textbox 7 and 8 is not...

I have this sql statement in a query SELECT Profile_Table.Profile_ID, Profile_Table.FirstName, Profile_Table.LastName, Profile_Table.Personnummer, Profile_Table.AnstalldSom, Profile_Table.JobbarPa, Profile_Table.WorkStartDate, Profile_Table.WorkEndDate, Profile_Table.JobbProcent...

In Power Query, I would like to perform transformations on certain columns that are dependent on the value in another column. For example, in this table, <tbody> Value Col1 Col2 Col3 Col4 A aaa 123 456 789 B bbb 123 456 789 C ccc 123 456 789 </tbody> On any row...

I have a TAB called KITTING. This TAB has the totals from 7 other tabs. The TABS are labeled STN, MDF, BACKBONE, CCTV, FIRE, ACCESS-IDS, PATH. Each of these TABs have the top row with PART NUMBER (B3), DESCRIPTION (C3), MANUFACTURER (D3), QUANTITY (E3), UNITS (F3). I would like to also add a...

If I have 5 arrays that have same dimension, can I combine them into one array with 5 subarrays. va = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp)).Value vb = ws1.Range("D2", ws1.Cells(Rows.Count, "D").End(xlUp)).Value vc = ws1.Range("F2", ws1.Cells(Rows.Count...

In the M language, do we have a function that checks if a value is either null or an empty string? Instead of the verbose EmployeeWarning = if EmployeeId = "" or EmployeeId = null then "EmployeeIdMissing" else "", Something like this EmployeeWarning = if IsEmpty(EmployeeId) then...

Hi all, First time posting here about access so any help will be greatly appreciated. I'm creating a user-form in access and due to the remit given to me i,m trying to avoid as little code as possible so therefore i'm trying to set some validation for a text box. it shouldn't be that...

Hi Folks. I trade stocks. I just created a macro in a "template" file called CIA Trade Blotter Template.xlsm to paste value the trade date from a range that contains "today()" and then save the file (downgrading it to xlsx) with a datestamp appended to the filename [i.e. CIA Trade Blotter...

I have a (model portfolio) macro enabled workbook with 3 company-focused sheets and 2 client-focused sheets. When changes are made to the portfolios on sheets 1-3 they flow to the nicely formatted sheets 4 and 5 via cell and name references. Then I ... 1) copy the last 2 sheets into a new...

I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...