statement

Hello, I am having dificulties with labeling or renaming based on a criterea within a text in excel. So for example in column A you have texts such as: 'Europese incasso door:ENERGIEDIRECT BV NL-109870104267/KLANT 13244336 KNMRK 200251063/FACT 46526999986 DAT. 19022018/Termijn 66 00 BTW 11...

Hi all, I wondered how to Return to the original row with a listbox I know with a short statement that's OK for the listbox for a determined lenght and height, I see the whole statement when I activate the userform. If OptionButton1.Value = True Then Me.ListBox2.AddItem ("blabla") But If I...

Hi everyone, I have a large data set where on some sheets, a filter has been applied to the top row. However, on some sheets, no filter has been applied to the top row. I would like to have all top rows filtered. Can IF statement be used to check whether the top row has filters already...

Hi there, For some reason i have an IF AND statement that is giving me trouble. I have tried several other examples on the internet that seem to work...yet the statement i wrote will not work properly. When 1 of the 2 statements if TRUE the code is already executed (which should only happen...

Hi, I have a spreadsheet which I have created large IF Statements in. It was all good until I tried to open it again and it took 10 minutes to open! I then realised the size has increased to 10k KB! Here is one of my multiple IF Statements (one of the smaller ones). In column B are 3 digit...

Hello. Was wondering if someone might help me with an If, TRUE statement for a range? I'd like the range to be 0-60. The other thing is that the lower value has to be equal to or greater than 0, and the higher value has to be less than or equal to 60.

I am having trouble writing a code to recognize if a number is odd or not and then determining what to do from there... It keeps pooping up with an "object required" error. Please let me know how I can fix it, or if you have ever come across this problem. Here is my code STNDRD=17 If STNDRDR...

I am trying to write an If statement using Data Validation drop down for a combined bank ledger. I am having trouble getting data to filter properly. I can get it to function with 2 selections but when I added the 3rd i can't figure out the statement order. Any help it appreciated...

Having trouble writing an IF formula. I'm unsure how to reference a 2nd cell with text in my first logic statement. I'll try to recreate it below <tbody> a b 1 Within Limits Reference 2 Must Pass Report </tbody> This is one of the formulas I tried =IF(B2="Report" and A2="Must...

Need help to get the IF statement in F89 working the way I need it to but I keep running into errors as I try to modify it. Here is the data in question: Excel 2016 (Windows) 32 bitEF81Pension without bridge$ 1,255.1482CPP$ 1,638.7983OAS$ 817.9784Average Gross Payroll (if applicable)$...

hello, i am trying to do an IF OR statement for a sheet that looks like this <tbody> Column A Other Non BAU Event-Use Comments Other-Use Comment Box </tbody> so i want it to return a 1 if the fields say either of those items i tried this but it didnt work: =IF(OR($A2="Other Non BAU...

In the below Macro, specifically the section in red, i am trying to and an AND formula but do not know how. In short, when the value is evaluated and it matches the "" "" format as shown, i need add a condition that say if the number in the cell with the offset of -5 of the row is 5080 then...

Hello, I'm wanting help with an IF statement. I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000 =IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000))) This is...

I am trying to join two statements but keep getting errors. Please could someone help me and explain how to join them into one statement? Both Statements work correctly on their own =IF(AND(A12>=$K$3,A12<=$L$3),"Sunday",(TEXT(A12,"dddd")))...

Hi, Can one use AND in a while wend statement: When I use this statement, it does not read the AND statement, so even though there is data in my last column it exits the loops. Not too sure what I am doing wrong, or if I should not be using While and AND in the same statement. Any advice...

Hello. I'd like to count a range of cells that contain any text using the formula: =COUNTIF(H11:H64, "*") Problem is that it’s counting all of my cells since they each contain an IF statement. How do I exclude cells that contain an IF statement that output blank? For example, here’s what one...

I'm using the following statement =IF(OR(C1="SAT",C1="Sun"),"Off","8") however I still want the ability to include that in a Sum. If the cell is a Sat or Sun the the cell =Off, if its not Sat or Sun then the value should = 8 This is a Calendar with required hours in each day, however on SAT...

Hello, I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance. =IF(B38<1,0...

We have a file that runs a few times everyday (m-f). For the ones that run in the afternoon depending on the size of each file it could end before 4:00pm or after. The file puts a end timestamp. After importing to Excel I use this formula to extract the time from the file...

hello, i am trying to use conditional formatting to format a cell with text based on the value of another cell. for example, if cell "A1" = "test" then cell "C5" = "result" i am using the custom format to output "result" and a bodged together if statement to carry out the function...