help formula excel

I'm having a bit of trouble creating a formula with too many variables, basically I need up to 5 variables. If K19 is between 1-10 then add c47*28 If k19 is between 11-20 then add c47*20 If K19 is between 21-30 then add c47*10 If k19 is between 31-40 then add c47*5 if k19 is equal to/greater...

Hey guys! Need some help! I've got a list of many ranges of numbers, these are all ranges for serial numbers for example 1-10 or 11-20. These are separated over two columns. Column D is the start of the serial number range, Column E is the end of the range. I want to be able to search a number...

Good morning, We have a number of large spreadsheets which are full of vlookup formulas between multiple workbooks. I have started replacing them with Index Match and this has worked really well. We have a scenario where Index match doesn't seem to work, and i would like some advise on a more...

Hey guys, I'm stuck: I'm trying to do a personalized budget worksheet, but am running into an issue. Column A has the item, column B lists it as a necessity or a wish. Column C represents the budgeted (expected) price of my item, and after I buy it, column D represents the true value of final...

Hello, I am having difficulty with a formula. My level of excel is pretty intermediate in the fact that I know how to perform basic functions/formulas, but this is over my head a little. So help is greatly appreciated! I have two worksheets. One is a reference table, and the other is where I...

Hello, I am currently very new at using excel so I was wondering if anyone could point me in the right direction. I have the following example of my data: What I am trying to do is to filled out yes or no in the column B based on the data of column A. For example as shown in the picture, A...

Hi All, My issue is as follows, I need to create a formula that says if it breaches a threshold (e.g. 5%) then you need to disclose. But if it breaches the additional threshold of (e.g. 1%) then you need to disclose also. If a number was above 5% then you would disclose, but you would also...

Hello everyone, I have listed car brands in a sheet and distributed them on several columns. (as follows) <tbody> A10 A11 A12 A13 A14 1 GRADE 1 GRADE 2 GRADE 3 GRADE 4 GRADE 5 2 Lexus Chevrolet Audi Alfa Romeo Chery 3 Nissan Dodge BMW Citroen Chrysler 4 Mitsubishi GMC Cadillac...

Can someone please help me with creating a formula which can take the average from a table, based on multiple criteria in both the rows and columns? My first table is rather large but this is the basic layout : <tbody> Time period : 1 1 1 2 2 2 3 3 3 Week number : 10 11 12 13 14 15 16...

Hi I am working on a priority list and encountered some problems with it. I would really appreciate all the help, thanks. What I am trying to do is to have excel automatically assign a specific number to the Urgency Column based on how many days the item is from the Due Date. <tbody> Priority...

I want to convert an input to desired output. Kindly help. In the output - the columns value should start from most recent (year) Input - https://docs.google.com/spreadsheets/d/1m6t5UczZHK1lWAVuIVY2Amu8H8zQK6G8pJrsO-8HSPc/edit#gid=0 <tbody> INPUT EmpNo Year Qualification 125 2010...

Hi Guys, I am completely stuck on this and could really do with some help. I am trying to display a column title when a unit sale (indicated by a 1) is placed below in the rows. The current set up I have, which is working perfectly is...

So I am using a spreadsheet where on 'Page 1' I have a list of 10's of thousands of dates ranging from 2006 to now, (thousands because some days repeat), however there isn't a listing for Every date in that range. On 'Page 2' I have a form where I get the user to type in a date (In cell A1) in...

In column A I have a range of cells. Some contain dates and some contain just letters In cell F I would like to show how many have a date. In cell G I would like to show how many have the letter L I tried using this for the date portion as an array formula...

I have two work sheets where I am using a vlookup to return data (a status to be more specific) The result could be one of 16 different statuses that we use. What I would like to do is, based on the status that is returned, it converts to an abbreviation (See below for example) Right now I am...

Hi all, I am looking for advice/solution to a vlookup question. I have a Key that lists 16 words and their abbreviations. What I would like to do is a vlookup from one cell to another and then result converts to the abbreviation that is listed in the key without using some massive long...

Hey guys, I need some help. I need a formula that, sum from I7:I1000 if the cells A7:A1000 are filled with "RL1", and G7:G1000 are filled with TODAY() date, but i need to subtract the value of I7:I1000 if the cells J7:J1000 are filled with "OK". I don't know how to do that and I've been trying...

Hello everybody, I have this Excel document i use at work, i have a cell with today's date (B4) on it and a table where i have a agenda like with the dates (AC2, AD2.. and so on) what i need is that if the cell (B4) is equal to today's date in the agenda(AC2 or AD2 or so on) it changes the...

Hi all, I have been trying to find a resolution to this without getting any where here is my problem. On Sheet 1: Column No and Name: A(Job Number) B (Property Code) C (Where I want the Customer Number to be) D (Job Order Date) On Sheet 2: Column No. and Name: A (Property Code) B (Tenant...