value 0

  1. G

    Find Duplicate Values in Column, Return Time Between from Different Column

    This is my first post so please bear with me. I am trying to use some data to pull the lifetime of lithium batteries that I use. My spreadsheet is set up as follows: Column A: Object Battery is powering (Each object has a number) Column B: Second Object Battery is powering (if applicable)...
    • gdeboer
    • Thread
    • date duplicate iffunction index & match value 0
    • Replies: 3
    • Forum: Excel Questions
  2. C

    Help with SUMIFS

    Hello, I am working with a SUMIFS formula, where I want to target specific words in Col G (total of 40+ different words), and be able to reference their corresponding value in Col C, and add them up to give a total value. However, it always returns a 0. The formatting is in [h]:mm. I use a...
  3. H

    How to get 0 in place of #Value!

    Cell A1 & B1="" (null through formula). C1=A1*B1 I am getting #Value! I need 0 (zero). How to accomplish?
  4. T

    NPV not using timeline 0

    When using Excel to solve for Net Present Value using the NPV function there is no place to insert the initial cash flow found at 0 on the timeline and will always incorrectly solve the problem. If the initial cash flow is inserted into the first value it will apply interest to that value...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top