## If/Or Function Help

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”), …

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 …

In my highlighted cell I want to say:- If K25 has the letter G in and M25 has the letter G in and O25 has the letter G in then my highlighted cell would be G. …

Hi, Here is my issue. In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula …

hello, i want to write a logical function assuming in C2, for lets say if another cell in column A (i have about five thousands rows) is same as A2 and the …

I am trying to create a table to track how many times a referee has refereed a certain player. In my table i have as follows: Basically i want to count the …

Hello, Basically what I am trying to do is determine which batch number to use, by generating a value from a forumla, which will have a similar value …

Hi guys, Really desperate for your help here. Can’t get my head around why this formula does not work. Im using excel 2002 and trying to used If with …

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.