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 formula to say that if cell A1 for example has a value less than or equal to 21 then show "Low Anxiety", if it has value of 22-35 then show "Moderate Anxiety" and if it has value of 36 and above, then show "Potential Cause For Concern"
Solved by D. H. in 40 mins
Hi i need a formula to work out a percentage of a different box i.e. i want it to give me the number 12 if i put in 12% of 100
Solved by A. H. in 7 mins
if i calculate 1,486 x 10=1486 if i calculate1,4 x 10=14 What is wrong
Solved by F. Q. in 20 mins
I am using if and large function to sequentially arrange the values. If I change the value of one item then the entire sequence is changing. I just want to replace the changed value without changing the sequence.
Solved by D. J. in 20 mins
In cell H8, insert a nested logical function to display the required pet deposit for each unit. If the unit has two or more bedrooms (C8) AND was remodeled less than 10 years ago (cell H3), the deposit is $275 (cell H4); if not, the deposit is $200 (cell H5). Use relative and mixed references correctly. The pet deposit for Unit 101 is $200.
Solved by O. F. in 24 mins
5 Team Member solved different no of cases and gained good incentive however minimum case solved condition apply - So does not matter how much incentive they earned if minimum number of cases are not solved then they will get the fixed incentive of $3000. Will give you an example.
Solved by G. J. in 25 mins
i want to insert a multiplication formula in a cell if some percentage value is entered in another cell of same row. for eg. if i put a formula in G7 cell (=G2*e7) but it should be enabled or activated if i put some data entry in f7 cell Excel
Solved by Z. D. in 20 mins
01-07-2017 09:14:11 AM 9:14:11 AM I have two data sheets in excel that i'm merging into 1. one column is with date and time information, column next to that is just time that i have taken out of date and time cell, next to this i will need to say "True" if time is between 8am and 6pm Monday to Friday, everything else to be false
Solved by A. W. in 20 mins
How to subtract $100 only if in a cell A1 has a 1 and subtract $200 if the cell has a 2 and 3 if 3 4 if 4 and so on
Solved by G. L. in 25 mins
I'm trying to write a formula that would find the percentage of Customer Invoices that have stayed in the same Row rank (Column J) for 2 consistent months. The rankings are segmented based on the criteria in Column P. The sheet I'm working on is labeled Top X and the formula should be inputted in Q200:AZ212. The Row rank is found in column J, the Account ID is column B, and the Date range is in C (note the date range is Text, but the corresponding Dates needed for segmenting the data are located in Q2:AZ2. Please let me know if you have any questions!
Solved by K. Y. in 46 mins
1 2 3 4 5 61 62