logic functions

Hi all, I have a report that I am trying to automate as it just takes far too long to complete it manually. As main reference to edit my data, I have different titles from different jobs which the naming is not consistent. What I want to do, is identify which jobs are not in UK language, and...

Hi, I am creating a spreadsheet with several values (one Text value in each cell) i.e. <tbody> Row1 Col. A Col. B Col. C Col. D Col. E (The Result) Row2 Apple Banana NA Pumpkin NA Row3 Cherry Apple Mango Pineapple NA Row4 Apple Banana NA Pumpkin Apple </tbody> I wish...

Here is my worksheet example. I need a formula to count how many times the 'Service Level %' was greater than 79.999% for each day of the week. So for Monday, there is two data points, but, 1 would be my answer in this example. <tbody> Weekday Service Level % Calls Offered Work days Mon 81%...

Hi, I have 2 columns of dates E and J. At E there is always a date, at J there can be a date or it can also be blank. I want to say that if a date is <= at any date in E and if a date is <= J or blank, then show as Active, if not Inactive I came up with this statement =IF(and(E2 <=...

I have conditional format rule: =IF(AND($K$2>0.5,OR($L$2<>"Yes",$L$2<>"N/A")),TRUE,FALSE) I want, "If K2 is greater than .5 and L2 does not equal "Yes" or "N/A", then apply formatting, otherwise apply no formatting. I don't understand why my formula doesn't work, but it seems to just never...

I have an issue to resolve. I need to build a tax calculator as follows: if the price of an item (A1) is between $1600.01 and $3200 the item is taxed at 2.75% for only the amount over $1600 but no more than $3200. If the item is less than $1600.01 there is zero tax. If the item is more than...

I have a software called REVU where I can collect measurements off of a plan and export them into an excel sheets. I also have a previous excel sheet where I enter all my data. I want to be able to take the REVU file, upload it into my existing file and have my existing file search for certain...

I'm having a terrible time figuring this one out. Column B is Date of Training Column D is the trainee name Column F is the instructor name (there are two) Column I is the number of hours of training received by the trainee on that date I need a formula that counts the number of hours each...