Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

i need a formla to say if a colum is above 0% then its Marked as "Target OFF"
Solved by A. A. in 20 mins
if c1 is between 10% and 20% then "A" if c1 is between 21% and 30% then "B" etc etc
Solved by C. A. in 20 mins
I want to create a form, where if I ask question one and the answer is a particular thing it will automatically ask another question. i.e. are you male or female. If female then the next question would be are you pregnant? however if male is answered I don't want the other question to be shown. Can anyone help?
Solved by O. Q. in 34 mins
trying to creata a spreadsheet that has particular cells where a user would enter text and numerical data. i would want the whole sheet to be locked but if someone enters data in the first cell it would unlock the next cell for the person to move on to. this same code would run for the whole sheet.
Solved by S. H. in 60 mins
i have a column of numbers(d column), in the e column i want the cells to return nothing if the d column is not a 12 and if the d column is a 12 i want the e column to return the number of cells since the last 12.
Solved by O. J. in 60 mins
I need a problem solved.. I need to find out if someone scores 22/40.. what percentage of say 6.5% that is.. what's the formula?
Solved by M. H. in 18 mins
Sheet 1 col A = Employee number col B = Employee first Name col C = Employee surname col D = Full/part time col E = Yearly Salary Col F = Monthly pay Sheet 2 col A = Employee first Name col B = Employee surname col C = Dept col D = Payroll number col E = Full/Part time col F = Monthly pay Col G = I need a formula that looks at the data on sheet 1 and if the payroll number matches that on sheet 2 and column E in sheet2="full time" then return the corresponding employees Yearly salary from sheet 1, If payroll number matches but column E ="part time" then do monthly pay x 12. If none return 0. Please can anyone help?
Solved by D. U. in 14 mins
Can you help me to create a nested if formula, that will identify for the grade result of the corresponding Average Score?
Solved by C. A. in 20 mins
I need a automatic formula that I could use to change or "push" dates forward, for example, if I have a date of 18.06.2018 and I would like to change it to 01.07.2018. The dates are obviously not always the same so it would take me very much time to do all manually and that's why I would need a formula, can you help me with this?
Solved by S. Q. in 16 mins
i want to use today() formula to mins from previous date and if cell is empty then come to 0 in cell
Solved by V. Q. in 40 mins
1 2 4 5 6 61 62