Get instant live Excel expert help with Time and Date Functions

I need to create a formula that says if sales % is 90%-100% * Days worked by 10, if sales % is 100-125% * days worked by 15, if sales % is over 125% * days worked by 20

help me with a index/match formula. I got it working a few days back but now it doesn't work.

Hi, I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2). =(G4*G2)+(H4*H2)+(I4*I2)+.... Colum marked PROBLEM How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)

I want to have Cell "X" return the value of a statement if Cell "Y" is equal to Monday, but if Tuesday the value is a different statement, on until Friday. Is there an IF statement that works with days of the week like this? Thank you,

I have created a gantt chart in Excel, that highlights the cells with a color, according to the amount of days an activity has. I use a Conditional Formatting (CF) formula on a group of cells (=OG(J$6>=$E7;J$6<$F7) ) for that. If the formula is true, then the cells change color. My problem is, that the calendar includes Saturdays and Sundays (weekends). How can I write a formula in CF that will jump the weekends and count the rest of the days on monday. Fx. An activity starts on a thursday and last 5 days, then it shall highlight T, F, M, T and W. In advance, thanks for the help.

Use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [10%]. Compare these outcome figures. How do the mean and SD change with sample size? [10%].

Add a page break at Row 36 so that city data does not span between pages, and change back to Normal view. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Display the Filtered Data worksheet. Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain. Filter the data to display records for houses that were on the market 30 days or more. Apply the conditional formatting 3 Arrows (Colored) icon set to the Days on Market values.

I have copied and pasted all the formulas so they are the same and yet there are some days that will not copy from the daily sheet to the weekly sheet and a lot of my employees info wont show up.

Create a formula with structured references to calculate the number of days on the market. Apply the General number format to the values. Add a total row to display the average percentage of list price and average number of days on market. Format the average number of days on market as a whole number. Use an appropriate label for the total row.

Add a total row to display the average percentage of list price and average number of days on market. Format the average number of days on market as a whole number. Use an appropriate label for the total row.