Get instant expert help with Excel and Google Sheets

How to simplify below formula =IF(AND(F11=F2,G11="A"),"X",IF(AND(F11=F2,G11="B"),"X",IF(AND(F11=F2,G11="C"),"Y",IF(AND(F11=F2,G11="D"),"Y","Not Satisfied "))))

I am trying to create conditional data validations moving from cells left to right that change options as the previous cell is selected.

Hi, I am working on a formula which I want to say: If C94 and C21 are "Yes" then do this calculation but if C94 is "Yes" and C21 is "No" then do a different calculation. If both "No" then leave blank

Hello, I need to use the attached index formula in excel. But it is no working propoerly

Arguments: If type of Inspection is "JANJUN" then expiry date for any inspection conducted between January to June (in any given year) will be 30-Jun-(same given year), additionally, if the "JULDEC" inspection date is conducted between July and December (in any given year) then the expiry date will be 31-December-(same given year), lastly if Inspection is "GPEX" then the expiry date is simply +6months - 1day from the inspection date. The formula I need is all of those arguments in one because the type of inspection can change for the same item depending on the site it has to be used on. Need all the formulae combined into one formula.

I have a spreadsheet that is updated daily with car registrations . Is there a formula that can highlight the same car registrations on each tab when entered on different days automatically ?

Have 5 columns. the 5th is file paths for a imaged hard disk drive. I would like to read text from right to left in the 5th column, extracting the last 4 characters of the path, being the .EXT.... identifying the extension of the file... and allowing me to choose what .ext to keep, and hiding the rest... So... if .dat then hide the row, if .pdf then move on and leave it visible... Macro? VBA? Formula? I would be fine if it copied it to a new sheet for responsive hits of the extension i want... looking for doc extentions like .doc .docx .xls .xlsx .pdf.... .qbw ... .pst ... .eml .... maybe a few others... help?

Need to sum the month dates into year date --- ex: year 2018 is the sum of all months in 2018. Formula in I6 does not capture entire dates to the right by month into 2021. Same with all cells in green formulas fro cells I6 to N183. See attached.

Hi there I am asked a question that is asking me to calculate "Demand" What is the formula that I would use in order to find Demand?

Hi - i am trying to lookup a number value based on a pick list of clients with different charge rates. I want to be able to return the relevant pricing to the that client. I want to be able to have a different client / rates selected per row.