## Creating an excel formulae with multiple options

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 …

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 …

Ok here goes…. So I am trying to evaluate two sets of values in two cells let’s just say, for the sake of argument, cell A1 and cell B1. …

Hi – I’m trying to take the STDEV of averages for a given week. I know there is no STDEVIFS like there are for AVERAGEIFS so I found other ways …

Hi! I am having problems figuring out an Excel formula. This is for Excel 2010 on a Windows PC. I want to enter a number in one cell, then display a …

I’m working with about 4,000 names and zip codes of local volunteers on our registry. I need to sort them into specific jurisdictions based on their zip …

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

Hello, Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …

I am trying to create an if/then function with text…every way i write it i get error..I want to make it so if 2 cells that are adjacent both contain …

Hi I am trying to add the ISERROR to the below formula. I am calculating between dates to return a value or sum the amount of months in between …

BANK TRANSFER POS 1.5% CASH FORM OF PAYMENT 0.00 0.00 0.00 TEXT IF THERE IS A VALUE OF MORE THAN 0.01 ONLY IN BANK TRANSFER BUT ZERO IN POS OR CASH THAN FORM …

Hello, we are translating our webshop (more than 5.000 items) into German. As it is a lot of work to translate each product text manually, we plan to work with …

I am trying to come up with the formula for the following. If M5=C and N5=Y then BG5=1 If P5=C and Q5=Y then BG5=2, If S5=C and T5=Y then BG5=3. …

Hi, I’m fairly new to Excel formulas, so far so good. Until now. I’m stuck on how to word a formula. It’s a working schedule, therefore …

Can you help me combine these into one statement IF Cell X= “EL” and Cell Y>=1,”EL”, “DC”) IF cell X …

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.