Windows 10: Excel yielding 0 as quotient for currency values. Why is this happening?

Discus and support Excel yielding 0 as quotient for currency values. Why is this happening? in Windows 10 Gaming to solve the problem; I'm trying to get a value out of two cells containing non-zero amounts of currency, but I keep getting zero as the answer. The formula I'm using is... Discussion in 'Windows 10 Gaming' started by Joshua Feickert, Jan 19, 2023.

  1. JOSHUA FEICKERT
    Joshua Feickert Win User

    Excel yielding 0 as quotient for currency values. Why is this happening?


    I'm trying to get a value out of two cells containing non-zero amounts of currency, but I keep getting zero as the answer. The formula I'm using is =QUOTIENTc31,c34.

    :)
     
    Joshua Feickert, Jan 19, 2023
    #1
  2. DENT1
    Dent1 Win User

    Excel formula

    I need some quick help with an excel formula.

    I have about 500 transactions with different currencies. GBP, USD, AUD, CAD, EUR etc.


    Here is a list of some the transactions:

    51.96 USD
    13.38 GBP
    14.48 EUR
    28.98 USD
    26.98 USD
    8.95 AUD
    11.98 GBP
    12.98 GBP
    22.48 USD
    11.98 GBP
    13.98 GBP
    26.48 USD
    13.98 EUR
    15.97 AUD
    15.98 CAD
    15.98 GBP



    I'm looking for a formula that will add up the value of the ONLY the GBP currencies and ignore the other currencies.

    This isn't homework or anything. Taxes so need the answer urgently. Been playing around with Excel Tutorials for a week but cant find a solution.
     
    Dent1, Jan 19, 2023
    #2
  3. GFR
    gfr Win User
    Running Optimize literally does nothing; in PS it yields an error

    After doing a clean install of Windows 10 20H2 (OS Build 19042.906) and fully updating it, and updating all of the Dell drivers from Dell.com, I tried the following Optimize and Defrag options from How to Optimize and Defragment Drives in Windows 10 (tenforums.com/tutorials/8933-optimize-defrag-drives-windows-10-a.html):

    • OPTION ONE: To Optimize Drives in Optimize Drives Tool: Steps 2, 3, and 4,
    • OPTION TWO: To Optimize Drives in Command Prompt: Step 2, and
    • OPTION THREE: To Optimize Drives in PowerShell: Step 3
    The four steps attempted from Options 1 and 2 resulted in no notice action; i.e., it appeared as though nothing happened after executing the commands.

    When I ran Step 3 of Option 3, I received the following error message.

    What does this mean and now what do I do?

    Thanks!




    Excel yielding 0 as quotient for currency values. Why is this happening? 77d1617641823t-running-optimize-literally-does-nothing-ps-yields-error-powershell-defrag-results.png
     
    gfr, Jan 19, 2023
    #3
  4. LALA
    lala Win User

    Excel yielding 0 as quotient for currency values. Why is this happening?

    Pressing '0' (zero) yields 'q', regardless of keyboard and layout

    It doesn't appear like my layout swaps the two keys:


    Excel yielding 0 as quotient for currency values. Why is this happening? 99819d1485971499t-pressing-0-zero-yields-q-regardless-keyboard-layout-arenivr.png


    Pressing 'q' yields 'q'.

    And as I said, this happens regardless of which layout is used in Windows. My custom layout is called "atomic layout".


    Excel yielding 0 as quotient for currency values. Why is this happening? 99821d1485971499t-pressing-0-zero-yields-q-regardless-keyboard-layout-2fzb9it.png

    When "Norwegian keyboard" is selected, it clearly writes using Norwegian layout, and not "atomic".

    PS: Using KeyCodes3.exe, this is the output I get when I press the 'q' and '0' keys, respectively (couldn't copy):


    Excel yielding 0 as quotient for currency values. Why is this happening? 99823d1485971499t-pressing-0-zero-yields-q-regardless-keyboard-layout-axcshqz.png
     
    lala, Jan 19, 2023
    #4
Thema:

Excel yielding 0 as quotient for currency values. Why is this happening?

Loading...

  1. Excel yielding 0 as quotient for currency values. Why is this happening? - Similar Threads - Excel yielding quotient

  2. Excel yielding 0 as quotient for currency values. Why is this happening?

    in Windows 10 Software and Apps
    Excel yielding 0 as quotient for currency values. Why is this happening?: I'm trying to get a value out of two cells containing non-zero amounts of currency, but I keep getting zero as the answer. The formula I'm using is =QUOTIENTc31,c34....

  3. Input volume always resetting to 0 value

    in Windows 10 Software and Apps
    Input volume always resetting to 0 value: Hello everyon,I got a problem on Windows 11. I have an headphone with mic. But every time I went to a meeting no one can hear me. And when I check my mic setting the volume is around 0 ! I alway should fixe 100 but the volume decreases by itself !How can i fixe it by 100 ?...

  4. event id 41 all values 0

    in Windows 10 Software and Apps
    event id 41 all values 0: Hello i am experienceing a Hang randomly followed by holding the power. followed by an error code looking like...

  5. event id 41 all values 0

    in Windows 10 BSOD Crashes and Debugging
    event id 41 all values 0: Hello i am experienceing a Hang randomly followed by holding the power. followed by an error code looking like...

  6. Transfer Excel table value?

    in Windows 10 Installation and Upgrade
    Transfer Excel table value?: Hello, there is a function that can do the following: In table 1 I enter values that are often used and sometimes new values are added. But now I want that all values which are in table 1 are listed in table 2 so that I know which different values are available. Excel...

  7. Output Excel value from undefined row?

    in Windows 10 Software and Apps
    Output Excel value from undefined row?: Hello, I have the following problem: I want Excel to display a value from column "C" ,say 1; this is no problem. For this I use this: = IF(COUNT IF(C21:C70;1)=1;"Yes";"No"). How do I get it now that from a cell which is in column B next to the 1 is also displayed where the 1...

  8. Bug: Currency decimal digits showing incorrect value on build 1909

    in Windows 10 BSOD Crashes and Debugging
    Bug: Currency decimal digits showing incorrect value on build 1909: Hi All, We are using below code to get decimal digits supported by currency. NumberFormatInfo.CurrencyDecimalDigits VS 2017 For windows build prior to 1909, it was showing decimal digits as 0 which was correct for Colombian peso es-CO,COP In 1909 it's showing as 2....

  9. Battery is always on 0%. Why is this happening?

    in Windows 10 Performance & Maintenance
    Battery is always on 0%. Why is this happening?: My laptop randomly shuts down when I'm working with it, it doesnt work unless it's plugged in, and the battery is always on 0%. Why is this happening? https://answers.microsoft.com/en-us/windows/forum/all/battery/d07424be-c4b7-42fd-89ee-9199b5dadb39

  10. Pressing '0' (zero) yields 'q', regardless of keyboard and layout

    in Windows 10 Support
    Pressing '0' (zero) yields 'q', regardless of keyboard and layout: I'm running Windows 10 on a Surface Pro 4. I have made a custom keyboard layout in Microsoft Keyboard Layout Creator.I have 2 keyboards. One with norwegian physical layout. Using any of the two keyboards, and any layout/language input method in Windows 10 (English US,...