formula and functions

I have a workbook where I input information in specific cells to create combinations to calculate employee bonuses. My workbook has 4 tabs: Data Bonus Base Bonus Summary The Data tab is formatted like this: <tbody> Column A Column B Column C IF formula below Base Salary? Employee...

Hi, Im trying to add in some way of tracking debt of customers in a spreadsheet. So far the formula say if a date is over 60 days then it will say Recourse =IFERROR(IF(O2>60,"RECOURSE"),0) But i now need it to do the same thing track if an invoice is over 60 days but also if the customers...

Hi, I am using following formula in a cell to get data from another workbook. The formula is {=INDEX('D:\Offical\Calculation.xls]Sheet 1'!$B$2:$B$598,SMALL(IF('D:\Offical\Calculation.xls]Sheet 1'!$D$2:$D$598=L$3,ROW('D:\Offical\Calculation.xls]Sheet...

Hi There, I am trying to automate a report. I am trying to give specific criteria to 5 different things. Here is the formula critera =if(c2= 5 - "Very Satisfied",5) =if(c2=4,4) =if(c2=3,3) =if(c2=2,2) =if(c2= 1 - "Very Dissatisfied",1) I need to combine all of if formulas into one big...

Hey Collective, I'm trying to create a weekly report and I want the data to update the report autonomously every week from the TOTAL row to the report on a specified date. Is this possible to do? Data <tbody> Task List Investigated Engaged Completed Task 3 1 Task 1 1 Task 2 1...

Hi everybody! I want to calculate where i can change a table with, giving lets say 1,25. 1200 Those number is calculated with 1,25, but I want to calculate 1111 with 1,45. 2345 1111 I'am sorry this was difficult to explain. But please help. <colgroup><col><col span="7"></colgroup><tbody>...

Our customer numbers begin with A followed by four zeroes and a string of numbers. Example: A00002121256438 A00002178164211 A00002191112936 A00002152291978 How can I create a formula to remove the 4 zeroes following the letter A so that the...

Hello I am trying to create a formula for an employee schedule. I have all the employee's listed on the first page, then on the subsequent pages are the different calendar weeks and positions. So I'm trying to create a formula that says If Kim McLane is in any of these cells on the Jan 1-7 tab...

I'd like cell E433 to total the amount of entries entered into a formula in cell F433 where the formula is: =91.72+38+292.45+38.4+81.23+43.52. Additionally, the whole E column will use this formula. Cells in F column will either have numerical entries, or will have simply have "N/A". So I'd...

<tbody> AGENCY 1 CLIENT CONTACT PHONE COMPANY 1 Jane Doe 11111111 Joe Doe 22222222 Simon Blog 3333333 Sarah Smith 444444 COMPANY 2 Jane Doe 11111111 Sam Smith 5555555 Sarah Smith 444444 Steve Jones 66666666 </tbody> Hi Excel people, I have an workbook like...

Hello everyone, I have an difficult problem and i do not even know if this is possible in MS Excel. The question is as follows: The Excel file should automatically calculate the amount of palletlocations needed for storage. <tbody> Boxes Monday Tuesday Variation 1 0 0 Variation 2 140...

:laugh:

Sub reva() Dim LastRowColumnA As Long: LastRowColumnA = Sheets("Working Other Purchases").Cells(Rows.Count, 1).End(xlUp).Row ActiveSheet.Range("A1:AV" & LastRowColumnA).AutoFilter Field:=12, Criteria1:="=*Rate*", Operator:=xlFilterValues ActiveSheet.Range("A1:AV" &...

Hi All, I have an spreadsheet which consist of employee data and there revenue to generate an automate invoice. here is an image link https://1drv.ms/i/s!AnOR9mvtWzlzc6NUs4vHUtxOI5c M21 is the total cell which has name range as Total M22 is the StTax as name range. The grand total has...

I'm trying to use the TRIM function on several hundred rows, but when I try to copy the function down the column by double clicking the bottom right corner of the cell containing the TRIM function, the exact string in that cell is copied down instead of the formula. Does anyone know why this...

I own a small restaurant. I am redesigning my schedule, and want a column at the end that would tell me how many hours each employee is scheduled for. The issue is that if we close at 9, that doesn't mean the employees walk out the door at 9. They have to clean, count the drawer, prep for the...

hello i want calculate accuracy for different people by comparing three fields in the spread sheet i don't know how to calculate accuracy by comparing three fields ,any idea ???please help me

I have searched for this question but have not found an answer that works for my scenario. I have range J2:S2 that have flags (I'm just using the letter "x"). I need my formula to tell me if the range contains multiple x's (Multi), a single x (Single) or blank (blank). I was able to...

Hello, I'm fairly new to Excel and when I was last on here people were able to help me out with the formula i was working on, now I'm seeking further pity with conditional formatting please. The excel spreadsheet data is generated through a Microsoft query linked to another program so when...

I have researched and even attempted other suggested fixes for this problem, but am still unable to find what I'm doing wrong here. I have been working on forecasting our clinic system physicians' encounter numbers for the next year and wanted to sum all of the physicians' counts for the...