if statement and and or

Hi Gurus, Good day! I just wanted to ask for your insight as I found a code to merge accounts, however if the cell data is not the same, it will skip the code. Example: No Name Data 1 Data 2 001 Math 100 95 002 Math 100 95 003 Science 95 90 'VBA Code for Merging the Data 1 and...

I have a table where I record the start time and end time for Frac and Wireline operations on a well, and that process is repeated for each stage of the well. Sometimes we skip stages and no times are entered indicating that skip which messed up the Total Time calculation. I left "Stage 3" (Row...

I download a receipt report showing receipts with order numbers. Column A has type Sale and Credit. I wrote a IF statement in column E where it tells me that there is a sale that had a credit with the same order number, and if it did not it would say "No Credit". I am combining column A and B...

I am trying to write a formula based on the following conditions and it is not working IF A1 = "S", and B1 = 254 or 127, Use LIST NOLIST IF A1 = "F" or "M", and B1 = 254, and C1 is even, Use LIST EVEN254 IF A1 = "F" or "M", and B1 = 254, and C1 is odd, use LIST ODD254 IF A1 = "F" or "M", and...

A B C D E F G H Reporting Date Invoice ID invoice payment id invoice header id invoice terms date vendor number po/non-po flag supplier name 23-Apr-20 1900057573_5430_2020_0001064077 1900057573_5430_2020 0001064077 NON_PO GT TRANSPORT 2012 CO LTD 23-Apr-20...

Essentially what I am trying to do is Calculate number of years by subtracting entered date (T5) form original data (C5) Currently, my formula reads =IF(T5="n/a","",YEAR(C5)-YEAR(T5)) As a result, if T5 contains n/a, the cell will return a blank field. However, I would also like to add...

I am using Excel 16.13.1 Mac Background: My formula currently measures the percentage of completion between TWO dates based on a "current date" input. and IF the percentage is under 1 (or 100%) it does so If it is 100% or higher is says “Complete” Current Formula: O7 refers to Start Date, Q7...

Hello: Is there any way I can automate the "RANGE" column to use a formula that would return the A/B/C value if it's within that range I'm giving to the right?? I've tried if /or statements but I'm not successful Loc VALUE %of sales % cumm RANGE 1 $152,503.00 8.37% 8.37% A 60% A...

Hello, I am no expert with excel so please forgive me if what I'm about to ask is silly. I am creating a canned response tool for my department which allows users to pick which options were used. Currently I have it formatted as a list which works but it's not how I'd like it. I would like to...

Hello, I'm trying to make an IF Statement where one cell must equal "BZ" and another cell can't be one of several values. My current attempt is not working... =IF(OR(LEFT($O2,4)<>"0940",LEFT($O2,4)<>"0950",LEFT($O2,4)<>"0740",AND(AB$1=$Q2)),1,"") Any ideas?