Windows 10: Problems with my formula

I have an excel formula, until yesterday it worked fine, but today when entering information the results don’t change, that is for example (2+1=3) but if I change the one for two it still gives the same result (2 + 2 = 3). What is wrong?

:)

 

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".
  
  Results in Office - Microsoft Communitymsoffice_excel

 

Asus Maximus Formula

thanks for that input *Smile i've tried at the next step up (1008) and it posted but i got errors when i tested the memory, i had real problems getting corsair dominator xms2-8500 to work without errors at 1066, and in fact i failed to achieve it *Cry :cry: so i went off overclocking the cpu instead *Big Grin

4-4-4-12 timings work and so do 4-4-3-9 any further suggestions are most welcome *Respect :respect:

 

mobile excel formula

"Worksheet names—In a cell in a worksheet, Excel Mobile accurately displays names that reference worksheets within the same workbook. It removes names that refer to other workbooks, arrays such as ={1;2;3;4}, array formulas, or intersection ranges
from the name list. When Excel Mobile removes a name from the list, it leaves the name in formulas and functions. This causes those formulas to be resolved as "#NAME?" Tabs that are hidden in the workbook are not hidden in Excel Mobile."

http://www.microsoft.com/windowsmobile/en-us/help/more/excel-mobile.mspx

You may want to investigate SoftMaker's PlanMaker:

SoftMaker: Official Website

Pocket PC Mauritius omnia i900 avnya henriett