excelformula

I am working with an Excel spreadsheet that tracks client orders and payments. I have two sets of columns: one for client names and their ordered quantities, and another for client names and their paid quantities. I need assistance with a function that accurately updates the payment status based...

I want to make an Attendance system in which i have to calculate the 'Overtime/Deficit Time' for each employee. I have done this successively. Now the problem is when i want to add the total overtime/Deficit time i got the value error in adding negative time(Deficit). Please help me how...

Hi, With formula in cell E2 I have covered almost all scenarios needed in our finance report for variance analysis, except first two scenarios which has to be included in formula as well. 1. case is if first number is positive and second negative, give me =100% 2. case is if first number is...

I need an Excel formula that will find the word that has a certain text on it. In the table below, I've tried to show what I mean. In column A, you can see the word that needs to be found in column B of the text, and in column C, where the formula should go to get the needed word, I would...

Building an excel formula that if a store is required to be open til 1am and their sales from midnight to 1am is greater than 100 then "yes" if not true then "no"

I have a column as NOTES that contains data such as 01-feb-2022 text text text w. text date text a.text date text n. text date text t. text date text basically, w.a.n.t. are the stages the note is written for. I want a formula to check if w.a.n.t. is present in the cell. There are some...

Afternoon all, I'm in the process of making a calculator for my work place an have run into a slight mind block I'm trying to calculate differences on 2 variables which is based on a pass or fail scenario the code I'm using is this...

Hi guys, I need to create a short schedule about my backlog in my DB. As you can see I have 5 category ( PWHT ,MPI/PT, HT, RT, UT ) with a little backlog ( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB. DB range in Sheet1 A2:CC367 and also after...

I have code to where it takes a table and makes exact copies of them one after another. sheet one has a table that is 16 columns and when I run the code it will past the same 16 columns, for example A-P is the 16 then it leaves Q empty then pastes the 16 starting at R and so on Sheet two has 3...

Set SumRange = ReconWS.Range(Cells(2, AmountFilter), Cells(ReconRows, AmountFilter)).SpecialCells(xlCellTypeVisible) If Application.WorksheetFunction.Sum(SumRange) = 0 Then ReconWS.Range(Cells(2, MatchedItem),Cells(ReconRows,MatchedItem)).SpecialCells(xlCellTypeVisible).Select...

Sub Mail_workbook_Outlook_1() Dim UserInputToEmail As String Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) UserInputToEmail = Application.InputBox("Enter your email id") On Error Resume...

I am currently trying to use a formula range to automatically move along a column every month based on values up until the current month. When a new month begins the formula should extend its range to the next new month and extend the sum. Each month ranges up to 4 years worth. the error seems...

I am hoping someone could help me with an excel function I am struggling with. I have two tables one in sheet one and one in sheet two (as shown below). I want to generate an excel formula that will sum all the values for Q1 - Q4 that match each fruit name in the summary table on sheet 2. So...

Hi Guys, I am trying to develop a formula which can help me do the following: 1. Looks up for two specific values in two separate columns 2. Looks for the first value in a third column and also looks for the second value in a fourth value 3. If both the first value and second value are found...

I'm stumped trying to get my formula to do what I want it to do. The formula I am using is: =IF(ISNUMBER(SEARCH("2003",F4)),"NOT OK","OK") and the goal is to search for the text 2003 in a cell. This formula works perfect for cell F4 when the text is something like: "Microsoft Windows Server 2003...

C8 = "20" , K8 = "$1000" , K22 = "$2000" if c3 = "=c8" , THEN c2 = k8 = "$1000" if c3 = "=c22" , then c2 = k22 = "$2000" so if i just need to change c3 value , then c2 will follow is this possible? i want the formula in C2 cell thank you