falls

Does anyone know how to do this? Wanting to make a calculator where we input a number into a cell, say D1. IF the number falls within a particular range it gets multiplied by a particular number and the answer is displayed somewhere, say G1. If the number falls within range 6225-6725, then it...

https://1drv.ms/u/s!AmfNhO-qyFc5iSnpBImBa6_Ndu_U?e=U3dbXq Screenshot in the link above I'm trying to create a function so that the bills in the top left will auto-generate into the table for the different weeks. For example if a bill falls between the 1st-10th than i would like them...

Hi all, I'm note sure if this at all possible in excel but I'll give it a go. I have a table of data (Columns A-T) that updates daily and columns U-EC are all date fields (the start of each working week ie mondays) In the spreadsheet column T has a date in each row. Each row is a different...

the purpose of this filter is to find companies that have done survey 2-6 within the date range (28 feb till 31 dec in this case). but it copy the entire row and shows results that falls outside of this date range as well. is there any way to use vba to delete those cells that falls outside of...

Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <tbody> #d9d9d9[/URL] "] #d9d9d9[/URL] "]s_male #d9d9d9[/URL] "]Values #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #666666[/URL] , align: right"]0...

Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="171"><col width="152"><col width="112"></colgroup><tbody> #d9d9d9[/URL] "] #d9d9d9[/URL]...

Hi guys, Would love to know if what I am trying to do it possible? Breakdown of what I'm looking to do is below. Column D configures the markup percentage based on the value range that Column C falls within. This range is on sheet 2 and contains the min. (A) and max. (B) range, as well as...

What's the simplest formula to use is I am trying to add up the values of column Y. If a cell in column a falls in the range of 3000001 to 3999999? Thanks

This is going to be a really complicated issue to explain but I am going to do my best. I am using PowerPivot for measures and PQ to clean the data. I am building a tool that projects energy charges for the next 12 months at facilities that my company owns. The way it works is the highest...

From the list below: Start Date,End Date,Names 12/10,15/10,Kevin 14/10,16/10,Jason 14/10,20/10,Kevin I manage to highlight the name if the occurrence is more than once. =COUNTIFS($A$2:$A2,$A2,$CF$2:$C2,$C2)>1 I need to create a conditional formatting to highlight second occurrence of Kevin's...

I have a depth sensor with an output from 0-60 I would like to add a value of 1 to another cell each time the value exceeds 5, but only once. when the value falls below 5 the cell does not change value and waits for the value to increase above the 5 threshold. I have tried a vba code which adds...

Can't figure out how to use PERCENTILE (or any other Excel function) to get a percent figure that represents just where between two defined #'s a 3rd # falls. For example, if: A1 = 5.2 A2 = 5.9 And I want Excel to tell me what where, in percentile terms, the number 5.3 falls between 5.2 and...

hello, my first post here, after many years of browsing and finding solutions! I hope someone can help. I am struggling to upload the image to the post but it can be found here: https://imgur.com/a/KJbTMg1 https://imgur.com/a/KJbTMg1 I am trying to get cell F6 to return a value from the...

Hello all, I've got a list of data in the following format: Name Date StartMetrage EndMetrage The start and end metrages are locations along a railway line where we have surveyed the track centreline. I would like to be able to look up a specific metrage and test whether it falls within any...

Hi guys! Basically am trying to work out how to make a formula that automatically calculate if a timestamp lands between the hours of 7:30am and 4pm. If it falls between 7:30am and 4pm I'm hoping for Status to say Business hours, If it falls between 4pm and 7:30am I'm hoping it says After...

Hi, I’m trying to return salary (from one cell) in to a cell next to the 28th (calendar as list) or Friday prior to the 28th if the 28th falls on weekend or bank holiday. Any help greatly appreciated. Thanks

Hey guys, I was wondering if you guys could help me with this! For example if the number falls between 0-15, to fill the cells adjacent to it with 1 "Name" and 2 "Age" (so 3 cells total) 16-30, to fill the cells adjacent to it with 2...

Hello All, I have a question and need your help to get the right formula. Here is the question, I have a set to values in Column A, Column B & Column C. The value in Column A (which is the important and they may change daily) but column B & C don't change. Value is the column A has...

Hello, Thank you in advance for your help. I have a complex formula issue, at least for me it is. I need a formula that has the following conditions: I need to count the number of times a word shows in column D but only if column E says "NEW" or "RET". Then I need to take that result and if...

Hello I need help with a formula. =IFERROR(LOOKUP(9.99999999999999E+307,SEARCH($A7,Sheet2!A:A),Sheet2!O:O),0) I need the above formula to not only find the match based on the above formula, I need it to also look at column K (a date column) and if the date in column K falls between a date...