# statement

1. ### Simplified IF statement

Good morning Demigods, Can the following IF statement be shortened at all...
2. ### 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.
3. ### 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
4. ### 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...
5. ### 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...
6. ### 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
7. ### 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 '" &...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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?
12. ### 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...
13. ### 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
14. ### 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.
15. ### 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...
16. ### 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...
17. ### 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...
18. ### 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.
19. ### [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...
20. ### 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...