if statement

Hi there, Cell H15 is formatted to text and has the following formula in it; =IF(F15<>0,426,"") I have other formulas (INDEX/MATCH/VLOOKUP) which refer to cell H15. If I just type 426 into H15 everything works fine, but if it returns 426 through the IF statement above, it returns errors on my...

I am trying to AutoFilter (in column A of SHEET 1) the Active Cell in SHEET 2. Then I have an IF Statement that counts the number of Visible Rows, and if it is more than 1 (to exclude the header) then I would like to insert a new row into SHEET 3 and cut and paste the values of the Auto filtered...

Hi, I was sure that the following code below changes to Red if my Cell from E34 ( 1 ) and Cell (Q34) is ( 0 ) then please change my Textbox to "RED". Can someone check please - cause it aint working. Private Sub Textbox32_Change() If Sheet5.Range("E34").Value > Sheet5.Range("Q34").Value Then...

Hi, I have been trying to figure out this formula for sometime and feel it's now time to call in the experts. A2:A10 Account Code (format ### or ###/###) B2:B10 Account Description (text) B15 - This is a manual entry tab, you enter the account number B16 = I want this cell to return the...

i want to populate information from range("A3:H40") to listbox only if Cell in Column("H") is colored red. the provided code list them all, even when a cell in column h is not red. Dim lbtarget As MSForms.ListBox Dim rngSource As Range Set rngSource = Sheet1.Range("A3:H19") Dim RNG As Range Set...

I want to be able to check (This is the first With statement) if a certain cell value ("H4" in this example) in the open worksheet (I refer to this worksheet as Sheet1 as it is Sheet1 in my workbook) where the code is being written (what is the proper naming scheme for this worksheet where the...

Goal: IF Column E is Blank AND Column M OR Column T are <0 True= "Review" False= Blank I can write the 'if/and' but when I include the 'or' my results are meaningless.:confused: Any help appreciated, as a solution will save me days of work.

Hi, I am sure, that I am missing something silly which is stopping me from getting the desired result. This formula is a small part of a project that I am working on. Can someone please look at the screenshot, and tell me what I am doing wrong? Condition: If C3 = NA and D3 ="" then E3 should...

So, I have a list of Yes/No questions and what I am trying to do is create a string of the terms that have a Y beside them. For example in the data below, I would like the cell to return Agitated, Angry, Depressed and I will reference that in a different part of a sheet. I would like for this...

HI, I am trying to create a savings log which would enable us to detail down the savings we generate as a business. Essentially the main issue I am facing is that I can dedicate fields to detail the saving total along with a date that can be used to identify a realisation month for the saving...

Hi there! I am trying to calculate the average of cells based on text criteria. I have to use the same column for the data I'm pulling, however, for each value I need, it requires a different set of cells within that column and I cannot get the formula to work if I don't use the whole range...

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.

Hi all, I am looking to copy a cells info from one workbook [File1.xlsm] (IF it meets a certain numerical criteria from a diff cell/same row on the same sheet/workbook [File1.xlsm]) to a specific cell in a separate workbook [File2.xlsm]. My digging so far has lead me to this formula (which...

I'm needing help with as time range IF statement I'm working on. I have in Row 1 (starting in Column D) time listed out in 15 minute breaks starting at 6 am. It is in military time currently. (06:00, 06:15, 06:30, 06:45, 07:00.... 23:45, 00:00, 00:15....) In Column B2 I have the start time...

Could you please advise if its possible to have an IF formula statement in cell B7 when two conditions are true, one of which is using conditional formatting (red bold text based on a formula condition in another validation cell)? <tbody> A B 1 NAME TITLE 2 Mark Manager 3 4 NAME...

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...

=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...

Hi Commnity, I have a formula I am trying to compile to return to me with who's anniversay date it is from a range of employees and their corresponding hire dates. I know that a IF statement generally works to find the first TRUE logical evaluation and then stops, but if there are multiple...

Hello, I'm not the best at this yet so please don't judge my code below... I am having a problem in the code where I highlighted it blue. I know there are some options like using an IF statement but I can never get those to work. We have 13 tabs for the 13 weeks in the quarter. As you can see...

Hello people, So, I have a little experience in programming and (very) little experience with Excel. What I want to do is to have a multiple condition check in a single cell, so it returns one string if a range of cells contains specific other strings, another string if it contains another set...