and/or

  1. D

    Formula to show whether invoice is paid AND/OR approved

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

    INDEX/MATCH & SUMIF (with one and/or two comma separated reference numbers)

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

    If A1 is populated then vlookup another spreadsheet and populate, otherwise leave blank

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

    How about a Word and/or VBA forum?

    ExcelForum has a Word topic -- why not here too?
  5. T

    Retain Cell Value

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

    Date Picker Help

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

    Vlookup and/or Index Help

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

    Question regarding the use of If Statement with multiple And/Or conditions

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

    Simple IF and/or question

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

    Strange If And Or issue

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

    Empty cell values when another cell value changes in Table environment

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

    Extract start/end times across multiple dates with multiple times

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

    Delete button

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

    Delimit alpha and numercial data

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

    Right click menu vba

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

    Can I used a nested IF function here?

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

    Countif and/or

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

    Countif AND OR

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

    VBA Use AND/OR to control multiple autofilters

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

    If/Then using a due date for a bill

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top