if statements

I have three columns as follows: Column A: Provides the number of days permitted to complete a task Column B: Provides the number of days that it actually took to complete the task Column C: This is where I need my IF Statement to calculate a simple Yes or No if the Actual Days to complete...

I am fairly new to writing codes and built the code below using others' codes, and modified to suit my needs. I send invoices everyday (which are pdfs). Sometimes I need to send emails with multiple attachments (based on if a customer has two or more invoices that need to be sent out for the...

Hi wonder if anyone can help me, I am doing a datasheet where I am looking for information from a main data sheet to report onto a front page sheet. Tab 1 is my main sheet where the info will be displayed 1st drop down box selects the tab to gather info from 2nd drop down box selects the area...

I am trying to do something, but I am not sure if excel can do it. In column C:C, I have a list of over 100,000 hyperlinks. These hyperlinks are very long and have a lot characters in them. These hyperlinks sometimes contains a project number. In range F2:F100, I have a list of project numbers...

Hi can anyone help with this one I working on a stats sheet and I have people with 2 different scores and a table for reference that gives them the ranking value. I'm not sure nested if are the way to go so any suggestions are welcome A1 A2 A3 A4 Agent Name Score 1 Score 2 Rating...

Hi, I need to be able to say if a specific day is between two others. More specifically if I tell you my store is open from Monday-Friday I want to be able to check if Sunday is between them. If it is, I consider Sunday open. This should returned "closed", but Monday-Friday should return open...

So I know that Excel supports basic programming statements like the ever useful IF statement. I was just wondering if anyone knows if it is possible to use these types of statements in Access? I am aware that access does support Iff statements, but not IF in the query sections of access.

Hi everyone, Im trying to create a tracker that displays the current grade of my class to the main dashboard along with the progression number which is determined from the predicted grade to the current grade. say they were predicted an A and the current grade was a B the progress would be -1...

I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty. Is this possible? I need to stream line some worksheet process building reports for management. I only have one stumbling block left regarding the following formula...

Hello, So I've been trying to tackle this issue for way too long by now. My last resort is asking here for help: It's an optimization problem i need to solve with Excel Solver. I'm encountering my problems when i want to use IF statements but they don't work with solver and I don't know in...

Hello, I am working with a report where i need to sort through associates names/different job positions/titles in a table in columns 2&3 THEN copy column twos values and add it to its designated spot(next empty row) based on that associates job title. the vba that i have pieced together does...

Hi, I have a data sheet with the following columns. Skill Name; Assigned Chats;Transferred Chats; Conference Chats; Total Chats; Average Worked Time; Averaged Wrap Time; Average Handle Time My hope is to sum the product of cells in Column E (Total Chats) * Column F (Average Worked time) when...

I have a spreadsheet where I am calculating average GPA by month over the course of three years. The data is pulling from a table I have on another spreadsheet. I want to find the 25th percentile for each month. The formula i'm trying to use is...

Hi I am trying to check if the cell [@channel] condition is met before doing a index and match function...

I need to make a formula that will check to see if a client's name is part of a range of data and then return the value "Township" if they match. If they don't the value should return a blank. To do this I've used an IF statement and took the cells I was checking against and converted them into...

I have a nested IF Statement that if a single cell has one at of information. For example: =IF(A1="YES", IF(AND(B2="OLD",B3="DOG"),"OLD DOG",""), IF(A1="NO", IF(AND(B2="YOUNG","CAT"),"YOUNG CAT",""),)) The formula isn't that simple but it gives the basic premise of what my issue is. My issue...

Can someone help me please. I want to know how I can make an if then statement for employee pay. I have seven different levels of pay. B, C, D, etc. Under each level of pay are different rates. If level B compensated employees make less than 75 units then they should be paid $8 per unit. But...

A1 = PVT =IF(A1=_OFF,"Yes","No") The Defined Name of "_OFF" list officer ranks and PVT would not be one of them so the result should be NO. However, this formula doesn't work it returns a #VALUE! error. I was trying to avoid using a VLOOKUP statement for this to keep my formula a little...

Hi All, I will try and explain my problem and hope you can help. I need to identify data on one table using a vlookup, if that data contains certain text (ABC) i need it to then get the cell to display data from another cell within the same table. Below are fragments of the data set Main...

<tbody> The following is sample data: The first column is the original data: The second column is what I am getting when I use the formula in the third column. The fourth column is what I would like to get. I thought I understood nested iFs, but I am missing something. Thanks! 719 S ABERDEEN ST...