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...
invoice payment id
invoice header id
invoice terms date
GT TRANSPORT 2012 CO LTD
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
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”
O7 refers to Start Date, Q7...
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...
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...