statement

Hi there, I'm trying to use the value (text) returned from an If Statement in Cell (C4) as a condition in another cell (D4) but it does not seem to be working since the actual cell value is not the text rather the equation itself, is there a way around this or any other way to get it done...

I need an IF statement that keys off grades of C- to A+. Something like this: IF(B1>="C-",A1,""). I know that statement doesn't work, while using a series of OR statements does, but I wondered if there was something simpler than the OR statement approach which uses 9 substatements, e.g...

Hi I need assistance with an if statement formula that looks at a row and if 4 or more of the cells in that row range that spans across multiple columns are equal to a value then the statement is true. Attached is a screenshot of the data. Need the formula to go into N4 - if the value of 4 or...

can someone help me understand where my syntax error is in the below formula. I am trying to add the third if statement which is a date range criteria. when I enter it it says too many arguments entered for this function. I suspect I have an extra comma somewhere but I can not seem to see any...

Hi everyone I'm using the below code which works fine: =IFERROR(IF(J29="As Required","Confirm Qty",J29*K29),) But I'm trying to work out how to add another if statement into the above code at the end so that the following also happens: If K29="Item Not Found" then ALSO in L29 print "Update...

The SQL statement works in the query grid but not in the vba. I want a search box to pop up and I will enter the EquipID into the search box then it will load the correct records into a list box for that EquipID. See below for the SQL Statement. strSQL = "SELECT tblTag.TagNumber, tblTag.TagID...

I create a account Statement and Invoices Workbook File, First sheet is the account Statement, and after each sheet will be a new invoice. I want each time I add a new sheet as a new invoice, as Copy Paste, a specific data from a specific cells in that new invoice sheet will go automatically to...

=IF(G74<((I74)-(MONTH(TODAY()))), "ALERT", "") <colgroup><col><col><col></colgroup><tbody> MONTHS ON O/H ALERT EXPECTED DATE 0.3 ALERT 8/30/2019 </tbody> Hello! I can't get this formula to work correctly! I'd like to have the word "Alert" added to the center cell if the difference...

Hello All, Here is a question, I have a situation where i have a column "AD" that displays a date. The date listed should be 1 year from the date shown in column "AC", unless "N/A" is noted, then it should list the date for 1 year from column "AB". I really familiar with vba but i don't want to...

Looks like Excel's conditional formatting only has a green arrow up, but I need something to indicate increase cost, by using Red Arrow. I've tried the Char and UNICode and some give me those arrows, but there is no way to color code them? Any thoughts would be appreciated! I am just using a...

Hi, I am trying to automate a way of searching through my bank statement and returning a reference number based on the narrative that appears on the statement (sample data attached). We get hundreds of items every day and the narrative that is quoted on the bank statement is always different...

I have this code working fine, but would love to turn the if statement case statement into a function. Can somebody show me how to turn the if statement into a function. In essence I'm just trying to compartmentalize the code into small procedures. Private Sub Worksheet_Change(ByVal Target As...

Hi I want to use conditional format to change the text in B1 if it contains “pending” and A1 is >=today() to “paid”. If the cell contains any other text, I don’t want it to change If the cell is blank, I want it to stay blank I then will copy it down as needed I can’t use...

Hi All, I'm trying to load data from excel to sql server. For this I created an insert statement which is very generic means this statement can be used for any table. I just have to change the name of the sheet and it will automatically pick up the names of the columns and their values from the...

Hi all, I am using this code right here ActiveCell.FormulaR1C1 = "=IF(RC[-1]="",IF([-35]<>"",RC[-35],"Misc"),RC[-1]" Whenever I go to another line I get an error message that says "Expected:end of statement". I do not know why this keeps happening. It is probably something simple I am just...

Hello, I am starting with VBA and I'd like to know if it was possible to use list from a worksheet inside the code. I wouldn't want to create an array as my list is pretty long. I would like to have an if statement that goes like: If Range("A1").Value IN [a liste of value inside the...

Hello forum friends, I am trying to create an IF statement and again, I can't seem to get the syntax right. I have a cell (F9) that will either be blank, have an 'M' in it or have an 'F' in it. In another cell, I have the formula (shown below) to return 'him' or 'her' based on the entry in...

i need to use the if statement to see if the word "John" is a cell in a column. How do i word the IF statement. Jon can be anywhere on the text on the cell thanks all

Struggling with this one... currentRow is a Range destinationWorksheet is Worksheet How do I copy with values and format by modifying this statement: currentRow.Copy destinationWorksheet.Cells(rowNumber, "b") New to VBA and struggling with Syntax....thanks!

These 2 VBA expressions do not function as it the are documented to, and I found that these had been recently implimented and broke code I've been running for years. INPUTBOX The docmentation says that if you hit the "Cancel" key that the routine returns a FALSE. It now returns an Empty String...