if statements

Hi, I was hoping that someone could help me out on an if statement that I cannot seem to get to return the correct number. It seems right? I need to calculate a set %age of sales based on the sales number if =<400,000 then return 10% if>400,000 but less than 450,000 then return 12% of sales if...

Hi All, this is probably really basic but I'm completely new to IF statements and I haven't managed to find anything online that explains this simple task which I'm trying to do... Basically I have a bunch of dates in a column in a spreadsheet - let's say they're in column A. Column B is blank...

I have a rather large spreadsheet that gives me the following information: 10112 Biloxi MT Manager Trainee BOP Active 2 CSR Customer Service Rep BOP Active 2 MGR Manager BOP Active 1 10112 Biloxi BOP Active 5 This...

I think I need to do this in VBA but I have no idea. Here's what I need; to compare numbers in two different cells based on multiple arguments. For example, if the number in A1 is <20 and the number in B1 is >=60 then C1 Shows "Pass", if A1 = 21 and B1 is >= 61 then C1 shows "Pass". I need to...

I've spent quite some time googling to find an to the following but failed (hard to get quite right search terms): How to simplify the following formula: Simplifying IF(OR(A4=B2, A4=C2, A4=D2, .......... , A4=ZZ2), 0, "Error") To something of this style (though this doesn't work)...

Greetings. **New to VBA** I have created a financial document that contains a hidden worksheet (template to be called upon from a UserForm based on the month selected...the name is changed as it is copied). When the user hits "submit" on the form, the information entered gets transferred to a...

Hello Everyone, I'm really having trouble solving this - it's driving me crazy. I have a set of data with some duplicate ID's in column A. If the ID is the same, I would like to concatenate the values in the columns to the right with the rows below, but only if they're different. I found a...

<tbody> ARTURO DIAZ $30,000.00 Proportional Max % Max $ % Change Contribution Change Achievable Target Actual % of Target Achieved in Pay Sales Target (#) 50% 5% $750.00 3000 3500 $0.00 Customers Retained/Repeated (%) 30% 5% $450.00 70% 60%...

Hello, I have a sheet that contains columns of merged cells that have dates, Sunday to Saturday, as the heading. Under which are 2 columns (b/c the date cell is merged), that contain information. Column 1 and 2. Column 1 is the side header for the data in column 2: |Sunday, Nov 30| |Service...

I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both...

I am trying to create a formula to alert me when a data point is lower than a value (alert in red), when a value is within a range (alert in green), and when higher than a value (alert in orange)...all within one cell. Any help how to do so?

I am trying to determine the concurrent sessions, or time that is overlapped within PowerPivot or an Excel pivot for data set of sessions that have start and stop times (date:hour:min:sec). Column A contains the start times and column B contains the end times. Ideally, I would like to create a...

Hi, I have many cells each with different formulas for example: A1=G14/(1-$J$1) A2=G15/(1-$J$1) A3=G16/(1-$J$1) A4=G17/(1-$J$1) What I would like to do is to quickly insert the same if statement or at least partially in each cell above without having to change the pre-existing formula like...

Hi, There are two tabs in this example: First tab (Developments) pulls data from a second tab (Sensitivities) based on what scenario is chosen for a particular project. At the minute i have a need for 10 nested if statements (as there are 10 scenarios to chose from) but i don't think excel...

Hi there, Below is a formula I’m working on. I want, if possible, for excel to look in tabs "acctg" through "RM finish Bundling" for the text that i have in '2015 Consolidated!A96'. The formula works if i only use one tab, but if I could have it look through all those tabs, it would help me...

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

Hey Guys! I own a valet parking company :) I have a list for the guys that says which day of the week they are available to work. I have a list for the guys that says which accounts they have been trained at. I would like to have a data validation drop down list that cross references the 2...

Greetings, I could certainly use some expert help with this formula. I am trying to accomplish the following: If Cell H7 < 0, then put in "q" If Cell H7 is greater than 0 and less than 1, put in "u" If Cell H7 is greater than 1 and less than 5, put in "{" If Cell H7 is greater than 5, put in...

Hello, I am working on a formula that has many nested IF statements. I am calculating distances from stores, where the distances are in a matrix. Here is a short version of the formula to get from store to store...

I am writing a macro that checks the value of specific cells on a sheet titled 1-SUMMARY and unhides specific sheets if the value of the cell is greater than $0.00.