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
I am hoping that someone can help me with this formula. It seems to breach when I add additional SEARCH functions in a nested IF statement.
When I added the last criteria to find the word "Reclass" I get a #Value Error
YES the source cell is TEXT. I did check it.
YES the word...
Total Spend (inc. Forecast)
Max Budget (Overspend)
Can anyone help correct my formula please? I basically want to work out a single formula to use in F2 for the following rules...
I am trying to take a list of Product Numbers in Table 1 and put a Type description next to it based on which column the item number appears in a separate table. I can get the separate IF/Vlookup statements to work individually, but not all together.
Formula I'm using that doesn't work...
getting N/A errors for some reason.