Are you stuck on Excel or Google Sheets?

Hi. I'm trying to model the roll out of an activity over a number of years. The total number to be rolled out is fixed. Say at 10,000. So if the roll out period is 5 years, then it'll be 2000 per year. But if I want to change the 5 to a 4, all 10k will have been rolled out in years 1-4, and year 5 will have no roll out (and no cost associated with roll out). If the roll out is 6 months, they are all rolled out in y1. I'm trying to find a way of modelling this. Can you help?

Problem with content in a file - want to recover as much as possible If you trust workbook click yes clicked Yes Cant find my file. Using Excel 2016

If I have a sheet that pulls data from another sheet. How can I compare if the right data is filled in, after the fact?

I am trying to create an IF statement with a range. Example: IF B1 is >100 but <200 then 300$ shows up IF B1 is >201 but <300 then 425$ shows up IF B1 is >301 then 600$ shows up

If I have names of some persons that are repeated often in an excel file. Which function in excel will give me the nth row when I use argument like persons name and nth integer which reflect nth time repetition of that name?

Hi I am trying to write a formula that says If cell A has a date then use that date, if cell A has “not req” then use cell C.

I have a group of cells with information and I want to highlight the cells on a mac and no matter what i try if I highlight one corner and try to drag it it just copies the info from the first cell and deletes the info it is soooooo not user friendly

Hello, I would like to know if it is possible, to place permanent information in one worksheet - in row form - and mark that row as either "open" or "closed". If marked "open", I want that row of information to be placed in an another "temp" worksheet so that any new "open" rows are copied to the same sheet as the next value in line(row). THEN, once the original worksheet row is marked as "closed", it would remove it from the other "temp" worksheet. Is this possible?

I have a few columns of text in columns "A" and "B" I want to compare those columns to columns "L" and "M" in order to determine if these recurring names come up. I am trying to determine if a donor has donate from year to year and can't figure this out.

I need help with an IF statement in Excel. I work for a youth hockey organization and I have the scores of the recent games. A win of more than 5 goals or a loss of more than 5 goals is called a 'blowout' game. How can I write a formula to say if a value in a cell is >5 or <5, return the value of 1 so that I can simply count the number of 'blowout' games? If the answer does not meet criteria return the value of 0.