Are you stuck on Excel or Google Sheets?

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

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.

Trying to write a formula to pull all values from a cell that are LEFT of a hyphen "-", or all values if no hyphen

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,""""))

I have an excel query on a gsheet that only works if a date is entered in to an unrelated cell.

I am looking for a formula to SUM column L, if Column A matched the relevant date and column C matches the name

I need a formula that says: If column "C" is equal to any value in range A1:A21, then it is "1".

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

I need a formula like if F3 is the same number as F2, then put an x in E3

if a cell in this column matches a cell in this column, give me the value to the right of that cell