multiple if

Hi there, Just wondering if there's a possible formula to help with the below. I am after a formula for Column E that returns certain text when a cell/cells are not blank. So for row 2 for example, because there are values in only Column A and D; the result I am looking for would be the names...

Even with all the help I've received on this forum, this code is practically finished, but I'm getting the "LOOP WITHOUT DO" error. And I know what that means, I just don't know where in the code the error is being triggered. There are literally no articles I can find commenting on this many...

Morning, I have posted this before but not been to clear as I'm not sure how to attach an example spreadsheet. I have tried to simplify the problem. <tbody> Day 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00...

Hello, I'm trying to create code so that when a user enters an ID in A2, the city will autopopulate in B2, and the person's name associated with that ID will autopopulate in C2. <tbody> ID (A2) City (B2) Person (C2) N11111 Airville John Doe </tbody> ?? Does it matter whether I list...

=IF(MATCH(E:E,'TMC CSV Upload'!P$2:P$54,0),'Export To CSV'!Z$2,"misc",IF(MATCH(E:E,'TMC CSV Upload'!P$55:P$84,0),'Export To CSV'!Z$3,"misc",)) I'm trying to do a fill down so that cells if cells in P2:P54 match it returns Z2 or if P55:P84 match then it returns value of Z3 any anyone please...

Hi People I am trying to calculate a benefit $ value for a project. The project provides different benefits in different scenarios. I have to parameters with multiple value for scenarios. Parameter 1 - Is the project targeted at children? Values - Yes, No Parameter 2 - Which ice cream...

Hi Geniuses! so, multiple if statement, scenario; Various formulas giving a yes or no or (any other specific value) so i want the last column to be a if statement saying if the answer to any of the columns to the left is yes than be a yes if not then no. I got the below but it does not seem...

My data has a number in column 2 that I need to analyze against multiple criteria and return a value based on the analysis. In basic terms I need to look at the value in Column 2 and if the value is less than 2077, return A. If the number is 2077 or more but less than 10,000, return B. If the...

Hello, could you please help me with the task below? I need to find out, how much money is spent on advertising for specific landing page. So, in first row column D of table1, there should be a value $10,50 In row 4, column d of table 1, there should be a value $15,00 The logic is this: if...

I have spent literally over 4 hours trying to figure this out. Please, if you can help. SO, my boss wants me to have in a cell if someone makes less than or equal to 300000 then times another cell by 20% but at minimum the answer must be 25000 and in the same cell, if the person makes more...

Hello everyone! I've recently been using Excel 2013 on my free time and I wanted to create a Slot Machine. I've used RANDBETWEEN, IF and COUNTIF to display a price in cell L11 if three cells below it have the same words in them. It's working properly but my main problem has been with macros...

Could someone please help. I have multiple criteria that I need to check and give different answers for, it goes something like this: If C21 = A, then L8 = C30 x 1 If C21 = B, then L8 = C30 x 2 If C21 = C, then L8 = C30 x 3 If C21 = D, then L8 = C30 x 4 If C21 = E, then L8 = C30 x 5

Hello I am currently using Excel 2010, trying to calculte a sum based on multiple if statements. I have data similar to the following : Month \ User ID \ Payment 8 \ 123 \ £20 8 \ 124 \ £5 9 \ 123 \ £15 9 \ 125 \ £22 9 \ 126 \ £3 I would like to count the number of new User ID's each month...

Dear respected Excel-Boss, I’m experience difficulties with writing a formula in excel. The formula contains three different IF-functions in ONE PROCEDURE and should be do the following: If column A contains a cell with the text “x1x” and the corresponding cell in column B contains the text...

Hi there, Looking for a SUMIF for the follow. Have a table with several columns that I want to display data from in another table. I need a cell to display the total value for labour for a certain person for a certain period. Column B in the master table has the period in, column M has the...

Hi there, Looking for an IF formula for the following. Column D shows the colour given to an area of a building, Blue, Green, Yellow, or Pink. Each colour has a different financial value - I am looking for Column E to show the financial value depending on the named colour in Column D. Please...

Hi! I'm a beginner at VBA and I need some help. I'm using three data sets with district data. Some district have the same name so I want to apply an ID number instead of using the district names. I have a numeric ID in one of the data sets. I now want to insert that ID in the two data sets...

Hi There, I was wondering how I would go about making condition variables to use in IF statements. The end result of the code is to calculate the total number of hours that a project has been worked on based on a starting time and date and ending time and date. However, there are two breaks and...

Hello All, I am having another problem, I have the following situation.. I want to assign a value from a Table where the specific condition is given in the table itself. the problem here is i got multiple conditions before he can assign the right value and the problem is the list is for...

Hi Excel Wizards! I understand excel 2003 has a limit of 8 nested if's, so would be grateful for a solution on how to get round a specific problem. The table of data is approx 5000 lines with Columns A to W. Formula below which works fine, sits in Column X and will be used on all rows. This is...