Are you stuck on Excel or Google Sheets?

On a spreadsheet i have job roles and there average hours per shift. Different roles work different lengths of shift and these lengths are graded, IE less than 5 hours scores 0. Between 5-10 scores 1. Anything over 10 scores 0. Then another role hours logged between 5-11 will score 1. I've tried several IF functions that work for one role but can not get the formula to work for either role in the same cell

I need to match two column, if one number in a column number falls in a range within the 2nd column. The result is on track or off track. Condition: (Column A: Age, ColumnB: Rank1-8) Under Age 30, Rank 1-2 ontrack Over Age 30, Rank 1-2 off track Between Age 31-37, Rank 3-8 On Track Between Age 38-45, Rank 5-8 On Track Above 45, Rank below Rank 8 Off Track

Hello I would like to know if the following conversion is possible in excel in cell 1 I have date and time information currently formatted from the cell format menu as (dd/mm/yy hh/mm) in cell 2 I have the number of minutes that a process will take - this number is usually around 2,000 - 3,000 minutes in cell 3 is it possible to display the completion date and time of the process?

Hi, I am just trying to modify the format within a string after a specific condition. For Example: If a specific value is found, then apply some specific format (bold, borders, etc)

I need to look up data from two different sheets. I need to reference data in one column on one sheet with data in one column on another sheet. Then if they match have a Yes filled in on a separate column in the second sheet.

If I merged a multi-row, multi-column selection. Iand types some text into the merged cell and then unmerges it, what will happen to the text?

I need a simple solution Bank balance - 7000 (1) Less unpresented Cheques - 500 (2) Add cheques lodged not credited - 200 (3) Total - 6700 (formula = 1+2-3 However if 2 is made 0 the total shows an error. Can we do a IF formula for the same please?

I use a Google Sheet to keep track of prospective investors. The first tab functions as a master tab. Some of the columns I use to categorize the prospects. For example, if they are a candidate to lead for the next round, in the column, I would put a y for Yes. Then, I would like to have a separate tab that shows only those investors that I have flagged as possible lead investors.

I need to auto populate stuff from one sheet to other linked sheet. e.g. If i enter something in one then it automatically populates in the next sheet. how i can do it

Hello - I am working on an IF function that has multiple conditions that I will need to use OR for. Ex) IF(Cell A1 = "Apple", "FRUIT","") OR (Cell A1 = "Broccoli", "VEGETABLE", "")