## nest if statement excel

i have column A1 to A10 and another column B1 to B10 In my Column C1 to C10 the value is from any One of A1-A10 ( that is customer enter) If C1 = …

i have column A1 to A10 and another column B1 to B10 In my Column C1 to C10 the value is from any One of A1-A10 ( that is customer enter) If C1 = …

Hi, sorry, exhausted all searches. I want a formula to tell me if the IF function result is the true or the false result. A very simple example, I have: …

Hi, I have the following formula: …

Hi, I’m working on a hydraulic analysis calculation sheet and I’ve hit a wall. I’ve calculated the average and critial velocity but theres a …

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula: …

I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …

Hi, I have multi shifts as under; 6 to 14 = 8 7 to 14 = 7 14 to 22 =8 22 to 06 = 8 22 to 7 = 9 I am …

I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …

Hi, Could anyone figure out a formula for this? If A2 contains all the text (not an exact match) from any cell from range B2 …

Hi! I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!) Currently, the …

I am trying to develop a formula that analyzes a specific material that has multiple inputs on a datapoint (MS). There needs to be only one identified and it …

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index. For the …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

How would I find an IF statement if I also need an AND statement? Ex. “If any of the numbers in cells B1, C1, D1 are equal to 5, multiply them together, …

Hi everyone, I would really appreciate if someone could help me regarding a function I am trying to execute on Excel. By:

=IF(SUM($K2+$N2+H2)-$M2<0,VLOOKUP($B2,’Container QTY’!$A$2:$B$219,2,FALSE),”0″) Hello – i am not sure how to …

How do I write the following in VBA? If (“F2”) begins with 8: true: if (“H2”) is empty …

I need to use appropriate function or functions to compare column G to B10 and return “Over budget” message whenever the results are +5% and …

I think I have the first part of this solved but can’t seem to figure our the second part with Job Status. =IF(OR([@[Pay Grade]]=”D”), …

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

Hi there, I’m trying to put in a function that will return a value from a range of cells when I put a related value in another cell. In column A I have a …

Hello! I am working with Excel 2016 on a PC. I am trying to list client information from sheet 1 (Proposal Tracking) onto sheet 3 (Client List). I have the …

I currently have this formula =sumproduct(––isnumber(match(Closers!A:A,‘Consent to Contract’!E:E,0))) This is counting all matching …

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

Hi, I am just wondering why my IF function is not working correctly. Any help is appreciated. By:

Hello, I need help with a formula. There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as …

Hi below is a basic spreadsheet for what i require. In the RATE cells i need the following input. I want a search to be done in the REd category column. …

Hi All, thanks so much for taking the time to read this, hopefully I am clear in what I am asking and doing everything correct according to the forum …

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–> up front/ annually quarterly/monthly $1,000 $4,999 5% …

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

Im having a little trouble with a code in excel vba. My goal is convert the following if statement to a VBA macro. The if Statement: IF(R8=“W”, …

Dear group below is a table that i’m trying to create a table for. its looking at dependancy ratio’s and giving a weighted score, but i have the …

I’ll outline the situation: I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, …

I need help writing an If/Then statement in Excel. I need to do ranges and the output differs based on the range. For example, if the answer of a …

I am working with data from a relational database exported to excel. A 6 digit code in one cell will drive what codes go into the other cells. The third, …

How would I go about copying a unique value from one sheet to another. For example, I have a unique value in Cell B in Worksheet 1, I’d like to return a …

Hello. I am trying to write an “IF” statement that has multiple parts and coming up short. The 2 conditions are: if cell K13 is blank …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.