if statement

I'm having a couple issues with formulas which i'm not smart enough to solve, I hope someone will be able to help me, I've added the minisheet at the end of this wall of text K to N is filled manually. Error: Q displays error "VALUE" if K or M is N/A, Q should remain blank in this case...

Hello there! I ran into some issues using VBA with my limited knowledge. I am trying to combine a code to delete pictures in a range, which works as it should: Dim pic As Object For Each pic In ActiveSheet.Pictures If Not Application.Intersect(pic.TopLeftCell, Range("A8:T35")) Is Nothing...

So I have a user who wants to use data validation in a project tracking form. And in addition, they want to do a chart that shows percent progress. So, what I want to do is use a nested IF statement that will use the values in the data validation dropdown list to populate a cell with a numeric...

Hello, I hope you're all well and keeping safe. I hope you can assist me with what could be an easy fix. I have two sheets, the first sheet is a summary sheet and the second is a raw data/ data dump sheet (please see example below): Sheet 1: Summary KPIs Week 19 Week 20 Revenue 100...

Dear users, I have to link cells from file 1 into file 2, but the problem is that the format of the two files are different. What I want is that... ... C9 (file 2) displays E3 (file 1) --> Both display week 46 - file type A - forecast ... D9 (file 2) displays L3 (file 1) --> Both display week...

I'm new to coding with excel vba, but i have an excel map with a list of superiors and a list of potential successor. Now i got the task to create an excel map where you can put in the position of a superior into an Input Box and it should automatically show you the successors that fit based on...

Hello forum, I have a workbook, that I use to import data into our ERP. I have 3 columns(E,F,G) that I will input a number into. I want to concatenate the 3 columns in Column H. While inputting nothing if the column is empty. EFGH1Depot 1Depot 2Depot...

Good morning, I have the following macro. I simply want it to look at A1 on the current worksheet, if that cell has data then move down to A2. Then the next time I important data it will look at A2 and paste in A3 etc. Not quite sure how to do this myself, any help is appreciated! Private...

Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris

Hi All I am hoping you can assist in how i would be able to writeup a VBA macro code that can resolve the below issue. Summary: Looking to create a VBA macro that can check the vins in the attached sample excel sheet “MOND94 – BUGS CERT -Checklist” where it will identify each row through a VBA...

Hello everyone! I was wondering you guys could help me out with creating a formula with an excel sheet that I've been having trouble with. So this is what I need: 1. If "TCG low price" is greater than or equal to 26, multiply it by .70 and put it in in "Offer" column 2. Find a way to replace...

I have a spreadsheet where the first sheet is a form using ActiveX controls (ComboBox, TextBox, and CommandButton). The ComboBox is a part number and the TextBox is a quantity. Once these are filled and the CommandButton is pressed, the information is sent to a master sheet with all entries...

Hello, My understanding of VLOOKUP function is that you cannot insert a range of cells as the lookup value. So, I am trying to find a workaround that only outputs data if the value in a 'lookup range' is not blank. Please see the attached original_data.jpg. I would like to return Customer...

Searching and trial and error have not gotten me anywhere, so hopefully, I can get a tip as to whether something is wrong with my formula, or if I'm using the wrong kind of formula(s) altogether. I'm working with a series of billing codes, and one has a different rate of calculation than the...

Hello Everyone, i am looking for custom function which would check If contains "Dr" or "Cr" and replace the same will nothing and also multiplies with 1 if the word is "Dr" and multiplies with -1 if the word is "Cr". For example, following is the sample table: 268740.00 Cr 1652420.00 Cr...

Hi all, I'm trying to copy according to yes/no rules to another sheet. When I copy, I want to get rid of the blank spaces between outputs, but not have them duplicate either. Anyone know how to do this? Here's what I have so far: First sheet with raw data: ABCDEF1Name...

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

Good Day, I have read through so many posts and I'm not finding the issue that I'm struggling to solve. I am trying to include logic where my macro will stop if there is any missing data... The user, prior to running the macro, needs to move a sheet into the macro-enabled template. The sheet...

Hello all, I have a two sheet workspace. Sheet 1 is called Data and sheet 2 is Print Dates. In Sheet 1 I have in multiple columns three sites. Site 1, 2 and 3. Site reference is found in row 3. Columns A4:A80 are dates for Site 1, Columns C4:C80 are dates for Site 2 and Columns E4:E80 are...

Having watched a MrExcel YouTube video about pulling records based on a condition, I attempted to reorganise a large question bank we have for learners. Unfortunately, the formula doesn't seem to work as it's getting caught pulling correct row numbers and always returns 0...