if & else

First of all I am pretty new to xls formulas so sorry if my question would sound too easy for someone. So what I would like to do is the formula with multiple IF and greater/less. to put it simple 0~7 = 0% 8~9 = 50% 10~19 = 73%...

Dear Excel Community, How can I check if a date range passes through a month and give out the number 1 if it does. Im an intern at a company and every month i have to give a report for the workers council. In this report I have to count the number of interns and bachelor/Master thesis...

I make use of the If statement a lot and sometimes the formula returns a 0. When the main formula returns a zero I want it to show the dash character so I usually make a formula like this: =If(*Formula* = 0,"-",*Formula*) My main question is if there is a way to not have to repeat the formula...

Is there a way to perform a index match function if 2 conditions are met. I am able to get the correct results if I use the below function alone =INDEX(sheet2!C2:C2318, MATCH(1,(sheet2!A2:A2318=sheet1!X567)*(sheet2!B2:B2318="Replay"),0)) But I need to execute this function only if sheet1...

I am trying to create an IF statement that reads "Valid" if the current time is between the hours of 10AM and 3PM. To do this my idea was to have an isolated cell which contains a formula which displays exclusively the current time that can then be referenced in said IF statement. However, I...

I am trying to display a msgbox if a user selects certain options in a dropdown box. Here's the scenario. This is for a scheduling assistant I am building. Daily schedules have several cells with a dropdown lists that refer to the entire staff. I know the staff's availability, so I have...

I am trying to lookup only "DELIVERED" items and have it look up based on tracking number, then return the date it was delivered from Sheet 2 Col L to Sheet 1 Col J, but ONLY if Sheet 1, Col C status says DELIVERED, otherwise leave blank not some error code like Ref# or something else. Also, how...

I need help getting this VBA code below to work automatically across multiple cells. I was using this formula before =IF(S6=Q6, "MATCH", "NOT MATCH") and just copying it down to the next cell below, but that's not efficient with a larger data set. Help Need: I need the VBA code to look at a...

Hey Everyone I've been trying to figure out how to write this formula and I'm open to using VBA if need be but I'm super new to it so my knowledge is limited. Summary: I'm trying to get CELL = [sheet2] X but if X is Blank then CELL = [sheet2] Y, if Y is Blank then CELL = [sheet2] Z, and if...

Good morning, Is there any way to skip part of a macro? I'm trying to build a macro that will transfer information from an old update form to a new one but I'm facing a couple inconsistency's. I used a Find & Replace to update a cell to make a VLOOKUP work on another tab, however, I'm noticing...

Hello, I create a macro to calculate the time travel between two times which are attendance records; To calculate the difference between B and A So in this case we havec 3 conditions : - B is greater than A so you can make de substraction - Or B is less than A so it's an error from the...

I am trying to create a formula that answers the following question: What is the Tenure at the end of 2018 (12/31/2018) for a person that has a HIRED DATE before 12/31/2018 and has a TERMINATION DATE that is either within or after 2018. I really appreciate the help, I just cant get the...

Suppose someone has a taxable income of Rs. 1177810/-. The income tax slab is as follows: Sl No. Taxable income Range (Rs) Income Tax 1 0 - 250000 0 2 250000 - 500000 0 + 5% of Taxable Income 3 500000 - 1000000 12500 + 20% of Taxable Income 4 >1000000 112500 + 30% of Taxable Income...

Hi I am working on a spreadsheet that will calculate what hour a store should close based upon it's last hour or sales. The logic works like this: a) If a store has greater than $100 of sales in it's last hour, close one hour later. b) If a store has less than $50 of sales in it's last hour...

Hello, We have a simple break list at work. I spent a lot of time making a better one, but the manager said it's too complicated. I want to improve the one we have now at least a little. (screenshot attached) In this break list, when you click on a cell under the "status" column - you have 4...

Good afternoon. I want to determine an amount of pay in local currency according to 3 conditions [frequency of pay]: (daily pay, monthly pay, one-off pay) If pay is in daily mode, amount of pay is : daily pay = daily pay * 5 * 24 If pay is in montly mode, amount of pay is: montly pay * 6 If pay...

I have a VBA question on how to create a macro that will copy/paste names to specific worksheets if conditions are met. A few examples below of how the code should run through the sheet... B12 is Yes. Include is 1. Exclude is 0. Therefore, copy/paste NameG1 to cell A1 of Name_Inc_1. Save...