excel formual

In excel formula, we generally give the reference of cell range like A2:A101, if the value from A2 to A101 are in sequence like A2=11001 to A101=11100, is there any way we can give the actual value range (i.e. 11001:11100) in the formula instead of the cell range reference.

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...

EX: A1 cell EXP/089/20-21 # i try to find particular word to alert condition # find : /20-21 (this word fount to alert to other cell , "ok","Not"

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...