While working I created a spreadsheet that saves me alot of time daily but I'm stuck on a formula I need for the data in one workbook. I have a list of names in Cell A. That same list is broken down into different groups in other cells (Cells C, E, G, M). I am wanting a formula that I can enter...
Days of the week
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Days Number
Day
=IFERROR(IF(A10=1,A2, IF(A10=2,A3,IF(A10=3,A4,IF(A10=4,A4,IF(A10=5,A6,IF(A10=6,A7,IF(A10=7,A8))))))), "PLEASE ENTER NUMBERS BETWEEN 1AND 7")...
Good morning.
I am working on a problem in my Operations Management class and am having a problem with a calculation formula.
Question:
Wanda's Car Wash & Dry is an automatic, five minute operation with a single bay. On a typical Sunday morning, cars arrive at a mean rate of 8 per hour...
Hi Please can someone help me with a complicated idea if it is possible (i'm sure it will be)
so i have a excel work book for daily, weekly and monthly task's
in the first tab is an index of all tabs each tab is its own task i would like to mark "done" next to the task when complete on the...
Can someone help me with a formula that will match a cell in column B to a cell in Column A and if they match then bring back the corresponding data from column C?
Hello Experts,
Please help me here. I have a table like below
<colgroup><col width="69" span="4" style="width:51pt"> </colgroup><tbody>
Group
Min
Max
Price
G1
0
10
100
G1
11
20
200
G1
21
30
300
G1
31
40
400
G2
0
10
120...
Can someone help me in finding out a formula for figuring out first day and last of the month for a broad cast calendar. Example for Jun 1 2017, the start of month should be May 26th 2017 since Jun 1st falls on a Thursday end date would be normal Jun 30 2017, like wise for Jul 2017, the start...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.