and/or

Book1ABC1InvoiceApprovedPayment Date2150001/01/193150001/01/19415162501725018292103113121314InvoiceStatus151Paid162Approved173Not ApprovedSheet3 Hello guys, I have a sheet with invoice information which can be categorized as either: - Approved = there is a value in Column B but not in Column C...

Hello All, The following formulas work with a single reference number in a cell. The issue is that some cells contain two reference numbers separated by a comma (example: 123, 345). How can I modify formulas to account for one and/or both reference numbers?. Any help would be greatly...

Hi, I'm hoping someone can help me with a if, and/or, and vlookup formula. My formula would exist in A2 and perform a vlookup in another spreadsheet based on the value in A1, however, if A1 is blank I want A2 to return a empty cell value. I know this is possible, but I'm driving myself nuts...

ExcelForum has a Word topic -- why not here too?

A1 = 2 B2 = 5 C3 = 7 C3 is the sum of A1:B2. If I were to delete the values in A1 and/or B2 what formula is needed to "keep" or retain C3 as 7. Last calculated value to remain active. Thanks

Hi Everyone, I put the Microsoft Date Picker in a cell and I noticed every time I open the workbook I have to work the mouse wheel to get it to activate. Is this normal and/or is there a way around that? Thank You!

Hey everyone in Column A I have some random numbers and in Column C I have The missing numbers From Column A. Ex: <tbody> 2 1 3 5 4 7 6 8 9 10 #N/A 1 11 14 12 #N/A 5 13 18 15 </tbody> Using SMALL(IF(COUNTIF($A$1:$A$130,ROW($1:$130))=0,ROW($1:$130),""),ROW(A1)) IN...

Hello, I am trying to write a formula which encompasses all the following conditions, and am having trouble figuring out how to put them all into one formula with And/Or statements. Here's the criteria: If B2 = Full Time and F2 < 172 Or if B2 = Part Time and F2 > 160 Or if B2 = seasonal...

Good day to all. I have a table with multiple conditions with specific amounts if conditions are met, but Im stymied on how to create the IF and/or formula since the conditions have min/max ranges. Hoping for some help :( Thanks a lot! Sample table below: <style type="text/css"><!--td {border...

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>...

Hi I have a Named Table "T_1" that follows the pattern below: <tbody> 1 2 3 4 5 6 7 8 9 2 3 Header1 Header2 Header3 Header4 4 Val1-a to empty when val1-a changes to empty when val1-a changes to empty when val 1-a changes 5 Val2-a val2-a1 to empty when val2-b...

I have a spreadsheet with a large number of timestamped entries. Column B contains the Date and C contains the Time. I would like to be able to find the first and/or last event for each unique date. I've tried several approaches, but I'm stumped.

Hey all! Does anyone know what the vba code is for the DELETE button that is on the default form in excel 2016? I've tried multiple codes to delete my current record but it ends up giving an error in the project. The default form delete works fine with no issues. I was just hoping to do it from...

I have one column (9000+ rows) thatcontains data prefixed; Ann or Annn or Annnn chars. e.g. Z12 and/or Z123 and/or Z1234 which I wish to delimit into separate columns A data example of one cell is; Z12,Z123,Y1234,Y5678,Z1111 up to around 10 occurrences I havebeen using a formula to delimit...

Hi, Is there a code to add a title to right click menu and/or submenu without the use of xml?

Hello! Here is my formula.. =IF($A$2>DATE(2017,MONTH(L$3&"/1")+1,1),0,($D78-L76+L77)) A2 = today's date Column D = stock L76 = monthly forecast L77 = deliveries due in month L78 contains the above formula & as is referred to as the 'availability' So basically if the month is in the past the...

Hi, I need a formula which can do the following The cell containing the formula should equal 1 if: A-B is positive AND C-D is positive, OR; A-B is negative AND C-D is negative, OR; A-B is 0 AND C-D is 0 The cell should equal 0 otherwise. I've tried what I know but cant quite figure it...

Hi, I need a formula which can do the following The cell containing the formula should equal 1 if: A-B is positive AND C-D is positive, OR; A-B is negative AND C-D is negative, OR; A-B is 0 AND C-D is 0 The cell should equal 0 otherwise. I've tried what I know but cant quite figure it out. Thanks

Hi all, First post here, I have tried searching for a solution for what I need but haven't found anything yet. I have a set of 12 columns, each one linked to a ActiveX Check Box. Whenever a box is checked, the corresponding column filters on criteria "X" (there are only blanks or X's in any of...

I've been pulling my hair out all day... so I figured I should finally break down and ask someone. I keep a spreadsheet for my bills (who doesn't, I know). On it, I've always either copy/pasted the "Amount" in the applicable cell for when a bill is due, or a cell reference (in case it changes...