Windows 10: Formula error

Discus and support Formula error in Windows 10 Software and Apps to solve the problem; I'm trying to compute Gross margin. Should be a simple formula. Not consistent and accurate results now.Should be total - pricing file cost. See errors... Discussion in 'Windows 10 Software and Apps' started by bryanschmidt99, Mar 13, 2023.

  1. BRYANSCHMIDT99
    bryanschmidt99 Win User

    Formula error


    I'm trying to compute Gross margin. Should be a simple formula. Not consistent and accurate results now.Should be total - pricing file cost. See errors on rows 3-4

    :)
     
    bryanschmidt99, Mar 13, 2023
    #1
  2. FREDERIK LONG
    Frederik Long Win User

    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
     
    Frederik Long, Mar 13, 2023
    #2
  3. ARGH JIMLAD
    argh jimlad Win User
    Asus Maximus Formula

    thanks for that input *Smile Formula error :) 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 Formula error :D

    4-4-4-12 timings work and so do 4-4-3-9 any further suggestions are most welcome *Respect :respect:
     
    argh jimlad, Mar 13, 2023
    #3
  4. DAVEM121
    DaveM121 Win User

    Formula error

    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 . . .
     
    DaveM121, Mar 13, 2023
    #4
Thema:

Formula error

Loading...

  1. Formula error - Similar Threads - Formula error

  2. FORMULA HELP- Excel : Using 2 sheets

    in Windows 10 Gaming
    FORMULA HELP- Excel : Using 2 sheets: The website will not allow me to add any photo of any kind, so I have made charts. : SHEET 1Cell down Row ->DF6Enter Country NameEquals Load1CameroonRows go from 6-127DATA sheet 2's nameCell down Row ->BC29COUNTRYLOAD PERCENT30Burundi100%31Cameroon400%Rows go from 29-70I need...

  3. FORMULA HELP- Excel : Using 2 sheets

    in Windows 10 Software and Apps
    FORMULA HELP- Excel : Using 2 sheets: The website will not allow me to add any photo of any kind, so I have made charts. : SHEET 1Cell down Row ->DF6Enter Country NameEquals Load1CameroonRows go from 6-127DATA sheet 2's nameCell down Row ->BC29COUNTRYLOAD PERCENT30Burundi100%31Cameroon400%Rows go from 29-70I need...

  4. Brightness buttons not changing brightness as intended, instead following strange formula

    in Windows 10 Gaming
    Brightness buttons not changing brightness as intended, instead following strange formula: I use a laptop with Windows 11. Occasionally, if the device hasn't been restarted for a long time varies depending on exact case the brightness buttons will follow a strange formula when increasing brightness. Normally the buttons to lower and raise the brightness decrease...

  5. Brightness buttons not changing brightness as intended, instead following strange formula

    in Windows 10 Software and Apps
    Brightness buttons not changing brightness as intended, instead following strange formula: I use a laptop with Windows 11. Occasionally, if the device hasn't been restarted for a long time varies depending on exact case the brightness buttons will follow a strange formula when increasing brightness. Normally the buttons to lower and raise the brightness decrease...

  6. Does the Logitech Wingman Formula Force GP work in Windows 11?

    in Windows 10 Software and Apps
    Does the Logitech Wingman Formula Force GP work in Windows 11?: I'm trying to get this steering wheel to work but every time I run the software for the wheel I get little errors that say the drivers were incompatible and were blocked. I know I got it to work in Windows 10 but it has been a while. I'd appreciate any help....

  7. Excel error message for formula, nothing is wrong with the formula, cant get rid of the message

    in Windows 10 Gaming
    Excel error message for formula, nothing is wrong with the formula, cant get rid of the message: this message pops up everytime i try enter a formula. there is nothing wrong with the formula. i know this because i now have to create workbooks on another computer. if i try use any formula, even from existing workbooks with already working formulas, it wont let me enter...

  8. Excel error message for formula, nothing is wrong with the formula, cant get rid of the message

    in Windows 10 Software and Apps
    Excel error message for formula, nothing is wrong with the formula, cant get rid of the message: this message pops up everytime i try enter a formula. there is nothing wrong with the formula. i know this because i now have to create workbooks on another computer. if i try use any formula, even from existing workbooks with already working formulas, it wont let me enter...

  9. Excel error message for formula, nothing is wrong with the formula, cant get rid of the message

    in Windows 10 BSOD Crashes and Debugging
    Excel error message for formula, nothing is wrong with the formula, cant get rid of the message: this message pops up everytime i try enter a formula. there is nothing wrong with the formula. i know this because i now have to create workbooks on another computer. if i try use any formula, even from existing workbooks with already working formulas, it wont let me enter...

  10. Formula error

    in Windows 10 Gaming
    Formula error: I'm trying to compute Gross margin. Should be a simple formula. Not consistent and accurate results now.Should be total - pricing file cost. See errors on rows 3-4 https://answers.microsoft.com/en-us/windows/forum/all/formula-error/5a8163ee-0ebd-4082-bd95-b59ba3114164