I have a convoluted spreadsheet that has many rows of data that includes a common identifier in column A, a unique identifier in column D, and a unique date in column F. All the way over in column AY and AZ I need to conditionally populate the cell if the common identifier in...
Hello. I am trying to do a Nested IF (or maybe SWITCH???) for a cell in Excel. My cell that I am looking at could have 3 values (11+ Years; 5-10 years; < 5 years). One of the troubles is that they could put more than those values in the cell (such as "We have been in business for 11+ Years")...
I have a nested if and I am trying to add an if error message and I am not getting the context right can you please help..
if there is an error in I3 return review,
If B3=nothing return nothing
if I is not greater than .01 or lessthan -.01 return review else nothing
I have 3 consecutive columns which will either have an X or be blank. I have 3 IF statements which cover all possible scenarios, but am struggling to nest them properly into one formula.
This first one tests if the sequence of the 3 columns is XX
In Column G I have customer PO's listed- When Order Entry types in the PO description each person has their own style. I need to identify when the PO field has the term No Charge.. They could type No Charge, NO_Charge, No-Charge, NCSO, NSO, nc..( and others but these are the main ones)...
I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact...
Sorry. I know there is a simple solution to this and I’m just blind to it.
Calculating Sliding Scale Percentage
Current Formula in cell A46
This works perfect, however I need this formula to consider the value of A43...
I have some data where the networkdays to be calculated for each activity.
Also, the leaves of each person and the common holidays are to be considered in the calculation.
I am trying to create a formula that will do;
If C2 AND D2 AND E2 contain text (date format) then "READY" else "BLANK" in another cell.
If any of the three cells have a date it still needs to show blank, only when all three have a date can it show ready.
I have tried various If...
Hello, I am relatively new to VBA and am making a tool for work. In this particular part I am trying to pull the correct email from the sheet 'Active Contacts' by first looking for an exact match, then an exact match of the next column over (another contact name), then approximate match in the...
I'd like to write a formula that
i) checks that J1 is not blank
i) checks if the word "for" is NOT in a cell J1
ii) checks if cell K1 is equal to 0.
I've tried this formula but it's not returning the result expected.
I need help writing a nested if statement to solve for the "desired result" column. I need to look in between each of these dates and determine which was most recent to the "comparison date", and display the "desired result" tag.
The combinations on this are driving me crazy and I...
I have a problem with a nested if formula where what I need is a number to appear i a column depending on the numbers founds in another column.
I think I have something wrong in the formula because it does not work like that.
If someone could help me it would be much appreciated.
I am new to excel. I am trying to categorise numbers of employees in groups. In one column I have numer of employees and other has nothing in it and I am writing formula like this in the second column, if the number of employees is less that 10, then write 4-9, if less than 50 then 10-49 etc and...
I've been trying to figure out the best way to get data based on a current date and typically use vlookup but it won't allow 12 conditional statements to look at each month. I want to populate based on the current date retrieving from tables from each month assuming the table was extended out...
I have a report showing the monthly breakout of departmental expenditures with many fields (account, department, project code, program, etc). On another tab, there are mini charts for each account code represented within the report. Each mini chart has a number of criteria it looks for on the...
I work for a trucking company and have several years worth of load & payroll data.
The data is contained in 2 tables.
Table 1 columns are: date, truck, driver, load, miles
Table 2 columns are: week start, week end, driver, cost.
Each driver can do...
First, excuse me for my english. I hope you guys understand what I mean. I have the following data and conditions:
A1 = 7
B1 = 2
C1 = 9
(the answer would be 7)
A1 = 0
B1 = 5
C1 = 3
(the answer would be 5)
A1 = 0
B1 = 0
C1 = 4
(the answer would be 4)
A1 = 0
B1 = 0
C1 = 0