Windows 10: How do I make my formulas work I tried typing, using help, and the formula maker

Whatever I do the formulas don't work I tried:Typing out the regular formulaAsking Copilot and Chatgpt for the correct formulausing the insert with preview optionasking my teacher about the correct formulausing the formula generator the formula would stay as the formula only

:)

 

Vlookup formula not work on window 10 version 1902 & 1903

Hi Ranaraza

There are no reports of those versions of Windows 10 causing problems with Excel formula . . .

Did the formula you are working on previously work or are those new formula?

What version of Excel are you using on your PC?

If that is Office 2016, 2019 or Office 365, and those are previously working formula, please try repairing your Office installation

If those are new formula, please provide the formula that do not work and also the error you are seeing

To repair your Office installation:

Follow these steps to perform a full repair of your Office installation . . .

Open Control Panel - Programs and Features

Click Microsoft Office in the list of installed applications

At the top, click 'Change'

On the resulting dialog, click 'Repair' - choose the Online Repair, it is a comprehensive fix

That should fix any issues with your Office Installation . . .

 

average formula will not average

I can see three serious problems:

• The "IfError" function suppresses all errors in your formula. You must omit it while debugging the formula.
• You cannot use the "Search" function for a range of cells, only for strings.
• You are posting in the wrong forum (same as you did in January). For a formula as complex as this one you must go to a dedicated Excel forum. Remember to reveal the whole purpose of the formula when reposting instead of just casually throwing in the term
  "Average".
  
  Redirectingmsoffice_excel

 

Formula

Thank you so much!

The formula works very well thank you!

Great job!

Sincerely

Carlos