if else statement

Hi, currently writing a VBA where if the value of range I10 in sheet name Main is equal to 1H, then the value of range ("B20") in sheet name Part 1 would be January sub working() Dim reportprd as string reportprd = thisworkbook.sheets("Main").Range("I10").value if reportprd="1H" then...

Hello i have the following formula, and woul dlike to see if i can add something to it like an If else statement this is my original formula =IF($J5="","Set currency",IF($M5="Calendar",IFERROR(VLOOKUP($J5,'Foreign Exchange Rates'!$C$2:$F$201,2,FALSE),"No Rate"),"Please Fill Out")) but would...

Hi! I thought I had this - turns out I am rubbish. I basically want to return a value in N3, if F3 (text data input) contains a value in N2 (header), otherwise return 0 I currently have : =COUNTIF($F3,"*"&N$2&"*") which works great to return a numerical value, but i want to later get a string...

I want a formula that If sum of H1 & I1 less than or equal to 2 and if I1 is greater than 0 then H1*1000+I1*500 else H1*1000+I1*500

Hi, I am trying to have VBA check if the active cell contains the word that is in cell A5 on sheet 2. Here is what I have for my code. But it keeps comming back false. Can any one tell me how else to write this? The Active cell has Apples/red and cell A5 has Apples. If ActiveCell Like...

Hi, I am trying to write a macro to assign a set new of serial number to each row. For example, each row will be given a number (in sequence) after every 8 rows and when there are no other numbers below it, the code will go back up again to continue the pattern again. Any help on this will be...

The table is <tbody> SEQ acc bsb 1 123 4567 bas 456 789 2 123 4567 3 147 78999 </tbody> Below is the code Private Sub CommandButton1_Click() Dim InitialRow As Integer InitialRow = 2 Set BaseSheet = ThisWorkbook.Sheets("sheet2") FinalRow = BaseSheet.Cells(BaseSheet.Rows.Count...

Hi Members, I have this following code where, I tested it in all way, I feel the Else part of the coding is not working. Please help me to highlight where is the problem in this code. Why it does not coming in Else part. Regards Sun. STEP1 = Calculation If (condition) Then STEP2 = STEP1 - 1...