if statment

ABCDE26SCHOOL 2022July/AugSept/OctNov/Dec27Bill #:01700102Discount (-2%)Face:Penalty (+10%)28122#VALUE!$1,170.89$1,194.79$1,314.2729Date Paid:#VALUE!HomeStead AmountHomeSteadAssessed Value30$100.60NO31,45031PARTIALSDATE#VALUE!<- SHORT IN FACE32PAYMENT #17/18/2022 #1$398.27FACE33PAYMENT...

I need to use vbquestion 4 times as below 1. The first one asks if you need to upload the first file or not 2. Then asks for the second file 3. Then asks for the third file 4. Then asks for the fourth file 5. Lastly shows a message for the selected files using a string variabe if the...

The goal here it to create a summary sheet. In that summary sheet I need to reference sheet 1 that holds all the products. Sheet 1 has all the products in one column, but some of them do repeat. My thought is to create IF statement that could call out one product in sheet 1 for the entire...

Hey guys so I am having a issue getting my VBA to recognize my if elseif statement in macro. I want it to read the value of a cell and if the cell is not blank then copy the entire row say A45 to S45 and then copy it, go to a different sheet, insert a new row after the last row of data, and then...

I need to write a formula that returns one count for every unique index number that either shows: If there are duplicates: overall status = "new" but all subgroup status for that index = "finished" (like for Index 456) <tbody> Index overall status subgroup status Index Count 123 new...

Hello everyone, I am working on my personal budget and have hit a snag along the way. I am presented with a user form to enter payment data. From there the payment data is placed on a separate sheet (Payments). The payments sheet holds the item, amount paid, date paid and the confirmation...

Hi, I have a spreadsheet containing data. Column A - Contains Supplier (e.g. BG, EON, EDF) Column B - Contains Status (e.g. Open, Closed, Completed, Cancelled) Column C - Contains a Date If want a formula in Cell A1, that says for example. If Column A contains "BG" and Column B contains "Open"...

hi I am still getting to grips with some formula so any help is much appreciated :) I am trying to calculate a 1 point bonus when 5% is hit and a 2 point bonus when 10% is hit. rest of the weeks will be 0 as its a 1 time bonus https://www.dropbox.com/s/o5wodrhc66p9yg9/bonus.jpg?dl=0 I...

Hello, I have a spreadsheet, that has a graph chart. There is two sets of data within it, with 2 data sources. Within the Select Data Source, I have the two Legend Entries (Series) listed, which I want to be dynamic the Horizontal (Category) Axis Label will be static, as the data here is the...

I am doing a royalty statement where is the sale occurred on or after 01/01/14 the manager would get 15% commission and if the sale was after 01/01/14 then they would be 15% commission. I have been provided a spreadsheet that has the sales date as a range ( ex. "0110-0613"). I have tried using...

Why will this not work? Does anyone know how they could check each score in a range and run each cell through the If statment. Here is what I have. Thank You! Or if you have a link to where i could find the answer I would really appreciate that also.:) Dim Cell As Integer, result As String...

In cell H10 i have the following formula =(E10*F10*G10*0.2836)*(F10=0)+(F10*G10) in cell J10 the user will type in the letters CS or SS. I need the formula in H10 to look in this cell and if there is a CS the multipilier need to be 0.2836 if there is a SS the multipiler needs to be 0.3126...

Hi, Im trying to check column A for specific text and if it finds it put a value in column 2, i have multiple if statements and they work, the problem is if i apply the function to the whole row, it pasts "false" in column 2 and it ends up freezing excel because it does it thousands of times...

Newish to VBA and have stumbled into a problem I can't crack myself. What the code should do: I have a series of list box (eTag1) items contained within a cell, which are comma delimited. I use the Split function and then two For loops to run through each of the items in the cell and compare...

how can I make this work?!?!?!? if (g4>=800,"","R"),if(h4>=800,"","M"),if(g4 and H4<80,"M/R","")

I would like to put a Date Stamp in G:G IF A:A or B:B = 1 Bellow is what I have so far.... Thank You greatly in advance... Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range For Each Cell In Target With Cell If .Column = Range("A:a").Column Then Cells(.Row, "F").Value...

Hi, I have a list of city that i update weekly to see the revenue that being spent in those city. What i would like is to rank the top 10 city's in my list by week. I know i could do a pivot table but i would like to not use one as I am on a PC and other users are on a mac and it has...

Hello once again!!!! I have this formula that works but I need to expand it! This is what i have: =IF(K4="XR",IF(B4=INDEX(B$5:B14,MATCH(1E+100,IF(K$5:K14="XR,B$5:B14))),"",B4-INDEX(B5:B14,MATCH("XR",K5:K14,0))),"") This will give me a distance from once xr to the next xr but now i need to get...

I am trying to write a statement the rounds the calculated data to 1 if the calculated number is less than 1. If the calculated number is greater than 1, I want the calculated number to be displayed. For Example: Num 1 = 20 Num 2 = 40 Num 1/Num 2 = .5 ( I want to round up to 1 on this...

What I am looking to do with this code is I want to look at cells B4:I38 and first see if they have been locked, if so than when a user selects a cell within that range the below message box (in the code) appears. But if the user selects a cell outside of that range than no message appears. So...