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 have a scale rating from 1-10 i wana look for a fourmila to convert it to words . if 1-2 defintly wont recommend 3-4 wont reccoment 4-5 i might and might not and like this
Solved by G. S. in 60 mins
Trying to write a formula to pull all values from a cell that are LEFT of a hyphen "-", or all values if no hyphen
Solved by F. L. in 54 mins
looking for an Iferror formula that will bring back a blank value if a date is not listed. Currently using the following but want to add an Iferror statement: =TEXT(H2,"DDDD"). H2 is the raw date ex. 2/8/18. I tried =IFERROR(TEXT(H2,"DDDD"),"") but it keeps returning "saturday" instead of a blank cell. Any help is appreciated.
Solved by F. Q. in 20 mins
I can't get this formula correct, can someone assist? I am trying to create a date for our posting process based on the payment terms. If a customer is paying biweekly, with a start date of 3/1/2018, etc. I want to be able to run daily what customers will need to be charged. =IF(OR(D2="MONTHLY",$C$6+30,")*IF(D2="WEEKLY",$C$6+7,"")*IF(D2="BIWEEKLY",$C$6+14,""""))
Solved by S. H. in 9 mins
I have an excel query on a gsheet that only works if a date is entered in to an unrelated cell.
Solved by V. A. in 60 mins
I am looking for a formula to SUM column L, if Column A matched the relevant date and column C matches the name
Solved by Z. Y. in 16 mins
I need a formula that says: If column "C" is equal to any value in range A1:A21, then it is "1".
Solved by S. Y. in 28 mins
I want to set up a spreadsheet that gives prices based on a number value. For example; If there is between 1-10 of an item the price would be £50 If there was between 11-20 of an item the price would be £40 If there was between 21-30 of an item the price would be £30 I would like to be able to input numbers in one column and it give me the price based on that number in the next column
Solved by I. D. in 20 mins
I need a formula like if F3 is the same number as F2, then put an x in E3
Solved by Z. J. in 20 mins
if a cell in this column matches a cell in this column, give me the value to the right of that cell
Solved by I. H. in 15 mins
1 2 61 62