statement

  1. B

    Nested IFERROR/ISERROR statement

    Trying to write this formula and keep flat lining. If G2 is a error (always #VALUE ), return blank...otherwise run the below if statement IF(ISNUMBER(G2),"1","0") Can anyone help I am really struggling.
  2. H

    IF statement Help

    =IF(C7="Rosemont University",E7*$P$28,IF(C7="Clayborn University",E7*$P$28,IF(C7="Branch College",E7*$P$28,IF(C7="Eastern Wisconsin University",E7*$P$28)))) My issue is that I can seem to remove False from my cells. Any help is appreciated
  3. A

    working with hh:mm:ss formats and IF statements

    Hello I am trying to write an IF statement using date/time/hh:mm:ss data and would appreciate some help. I have ~ 150,000 rows of data so am keen not to review line by line. I have an extract of data with a date time stamp and I have calculated the difference between two times. eg: I have...
  4. JTL9161

    If then statement?

    I am looking for a IF statement that will: In cell A9;Compare Cell D9 with K9 and show the greater number in cell A9 BUT If D9 & K9 equal each other then compare E9 with L9 with the greater number showing in A9 BUT If E9 & L9 equal each other then compare F9 & M9 with the greater number showing...
  5. JTL9161

    Sumproduct with an IF statement

    I have this formula below. I need to add and if statement to it that if the total is less than 4 (<4) then just put an 0 but if 4 or greater (>4) then show the number. =SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192)) Thank You, James
  6. A

    SQL statement VBA : need to ignore blank values

    Hello, I have a VBA with an SQL statement. I need to ignore any values that are blank Below is portion of VBA: "SELECT * FROM Data.dbo.Contract_Summary_Workbook as w WHERE w.""ProjectNo"" " & _ "like '" & Lists.Range("C4").Value & "%' or w.""ProjectNo"" like '" &...
  7. K

    Programable Print Area?

    Is it possible to adjust the print area program-ably? I have a print area of say Cell A1 to Cell E50. This will do for 80% of my needs. Occasionally the table may extend another 15 rows or so. For this I would like to add a column F and use an "If" statement like If(E51 <>"", Set print area A1...
  8. E

    VBA - If statement, Clear contents, add data

    I am having multiple problems: I created an if statement that first clears out any pre-existing content and then adds new data to the cells from a Userform. The Userform has 5 tabs within a Multipage and when I set the first page as active I want the data to be exported into a BOM. I have a...
  9. C

    VBA If Statement Evaluating After True

    Hello: My workbook has 2 sheets, "Numbers" and "General". I have an If statement that runs at workbook close. If Sheets("Numbers").Range("BA2") = 0 Then Sheets("Numbers").Range("BA3") = "Correct" ElseIf Sheets("Numbers").Range("BA2") <> 0 Then...
  10. D

    Capturing if anything is in a cell

    I want to verify how to properly enter a formula that captures if anything is in a cell. currently I have something like this =COUNTIF(F:F,"*?") Is my statement accurate?
  11. I

    If then statement failing

    Hello all, I'm having an issue getting an IF then statement to work within VBA. I'm trying to have my spreadsheet format a text to columns if A2 is blank. (meaning if it hasn't been text to columns already) I've tried a number of different formulas. It's not skipping if A2 has data and redoing...
  12. J

    FALSE instead of null in cell

    Hello gang! Quick question hopefully with a simple answer. Why would I get a FALSE in a cell that I set = to ""? This is in a Select Case statement. TIA
  13. P

    conditional formatting help

    Hi, I need to have rows highlighted that have to meet 3 criteria in a table and was unsure what statement would be best, two have to be a specific text and one has to be above a certain number.
  14. S

    If ...else if statement using cut and paste to another WS

    I am trying to create a If...then....else if statement loop with a cut and paste function to another worksheet. I have one master data worksheet "CAS_PPDR" and I have a column E that has the GL category in it (Regular, BB, Overtime, Premium). Based on the information in that column, I would...
  15. S

    Power Pivot IF and Statement Help

    HI All, I am trying to create a calculated column using an if/and DAX statement in PowerPivot and for some reason I keep getting errors so I am not sure if its the formula or if I am completely unable to perform what I want. My formula is below, can someone please help =IF(([Actual Order...
  16. D

    If Error statement

    Is it possible to combine an iferror statement and a countifs statement into one? Here is my current countifs: =COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019",AACH!F:F,"Y")/COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019") My current statement is returning #DIV/0! which is correct...
  17. C

    IF Statement combined with RoundUp

    Good morning, I am trying to nest RoundUp Statement within an IF statement for a decimal place. For example if the value is 20.30 I would like it to read 20. If it is 20.50 it can remain the same. Your help is much appreciated.
  18. Z

    [VBA] Pivot Table make column headers show Day 12 instead of xx/xx/xxxx

    I wasn't exactly sure how to word the title outside of providing the actual problem itself. I have a pivot table that has a dynamic amount of informaiton. My current pivot table has 27 unique dates, the next one I run could have 30 or even < 20. The column header we use is the Received Date...
  19. M

    Streamline quick VBA statement

    I have several worksheets in the same Excel file where I need to clear the contents in these specific columns (A,D,G,J,M,P,S & V) starting at row 2 in each column. My worksheets are named (8am, 12pm, 2pm, 4pm and 6pm) - Here is the code so far that clears these contents but it seems like I...
  20. A

    if statement for Percent

    I have this if/then statement that doesn't run correctly. lbSL is a label on a userform that displays 5.5% and it should execute the first part of the if/then statement. However, it executes the second part of the if/then statement. My guess the code does not recognize the lbSl.Caption as a...

Some videos you may like

This Week's Hot Topics

Top