if

Hi everyone, I am working on a case management tool and am trying to identify 6 different types of renewals by comparing submission month, day, and year between two different cells. D2 is the certification period end date (renewal date), and D4 is the date we received the renewal form. I have...

Hi Everyone, I am trying to make the Balance column not show if the IN or OUT column has no value I am not sure if this is possible or not 🙁 This is where i'm currently at right now. If B17 is blank, calculate D16-C17 If B17 is not blank, calculate D16+B17 Any suggestion would really be...

Hi guys, I really need help to set up a logical solution to this. In 'Value' column I want to have a value based on time interval. If a time interval in a cell in Sheet 1 falls inside a time interval in Sheet 2 then take the values shown in Sheet 2, otherwise 40. See image. THANKS FOR HELPING

Hello, A formula I am trying to use: =IF(A2<>0, MAXIFS('Current 6 months'!J:J, 'Current 6 months'!A:A, A2)+MAXIFS('Previous 6 months'!J:J, 'Previous 6 months'!A:A, A2), "") Is returning weird results. It has to look over two sheets and return the latest absence start date from column J -...

I have a simple date and checkmark setup that is having problems. Prior to trying the ‘if’ and ‘or’ in the same formula I only was using if. Then I noticed I needed to apply a separate date depending on if something was done the day before or if it was being done on the current date. As you can...

I'm working on a spreadsheet to track how many delivery vans I've loaded each day. The loading sheets have barcodes at the bottom which I scan into my table. They're in the format T<trip><date_as_yyyymmdd>V<van_number>, i.e. T001A20221024V101. At work the people on the desk have a spreadsheet...

Hi, I have the following task and I am looking for the optimized solution. Please help. Problem statement. User inputs: B1: wage B2: income tax percent B3: social security percent B4: Age B5: =B1*(B2+B3) I need a solution to meet the following: If Age<30 then B5 <=10000 If Age>=30 then...

Hi all. OK, so I will try and explain this: I have a spread sheet for auto working out, Percentage, Then PASS & FAIL. I would like the PASS and FAIL cell to stay blank if nothing is put into the SCORE cell. (Score cell is a drop-down option) So, when from the SCORE drop down is entered, It...

Hello everyone, this is my first thread here in this forum. For quite some I am using excel now with great fun and passion. Thanks to this forum I was able to solve many obstacles when I got stucked. However, today I really need to ask for help as I am stucked for a few days already. So here...

=IF(A2:A11>=50&A2:A11<=59,"*","") The formula above gives me "#VALUE!" I am trying to get a "*" if A2:A11 have any number that is in the range between 50-59. So, if A6 (or any other cell) has 50 (or any other number up to 59), as shown below, I would get a "*" as a sign. Please help, thank...

Hi, I have below table that calculations depends on the country, if it's US or Canada, then there will be specific formula but if not, then other formula. I need a formula that I can use to replace below manual formulas that I have to update every time based on the country field. Any...

Not 100% sure where to start here. Once B11 equals $1,400 I don't want the sum(B6:$M6) to continue to be calculated. Prior to D6 being negative B11=$1,400 and I want it to stay $1,400. I hope I made that clear enough.

I am attempting to count multiple columns that will be filled with different information/values/text. If all of the Columns are not blank, I want the column to report out as "Done" otherwise, the column can stay blank or report out as "Not Done". Every IF or BLANK formula I try seems not to work...

Hello, I have a formula that finds a keyword in one column and places a different keyword in a seperate column and if it does not find it it is left blank. That works great but I want to do this with multiple words on the same columns. I have tried using AND/OR but it does not work. Here is...

I have a spreadsheet that pulls personnel details from my main sheet (Nominal) to my other tab. B1:B50 with contain staff numbers when they are required. so while the tab is empty is shows #NA. When i put the staff number in the formula works fine. I was wondering if anyone could help to see...

So i have 3 sets of columns with data. How can i write on the right side of excel a formula that would do this IF there is data on Column T, then select that data, if the data is 0 or blank then use column AD, if that column is 0 or blank , then use column AG, if that is 0 or blank just have N/A

I am working on a table with arrivals and departures for airlines at my airport. I have two columns, a time column (HH:MM) and a delay column. I want to annotate in a third column whether the airline departed early, late, on time, or was canceled. I can get the early, late and on-time ifs...

hello all, I am open to suggestion on how to build the pivot table i am after OR just the formula to return the value i need to then try and build the pivot table. Thank you in advance!! I am trying to create a pivot table template that will return a view by name if any area in certain columns...

Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...

I'm having trouble removing the "FALSE" statement in Block G7. My goal is to have Block G7 populate a value based on whether the Check Box is clicked in cells B7:E7 . The boxes are not dependent (only one should be checked at a time) but when no boxes are checked, I would like the FALSE...