0 value

  1. B

    Remove 0 value cells from Vlookup results from two sheets.. HELP please

    Good morning guys, i am in dire need of your expertise.. i am doing a Vlookup between two different sheets.. it works no problem... =IFERROR(VLOOKUP($A2,'RAW Certus'!A:O,11,0),IFERROR(VLOOKUP(A2,'RAW SF'!A:Z,20,0),"OOPS!")) But u would to remove the cells that display a 0 value...
  2. A

    Making cell 0 if less than 0

    Hi and Happy new Year to you all, Would just like to know how what i need to add to a formula so that if the result is less than 0 it returns a 0 value? Currently i have the following: =IF(A4<>"New Car","N/A",IF(AND(A4="New Car",U4<>"Sold"),($AE$1-$M4),IF(U4="Sold","")))
  3. C

    Help Streamling Hide Empty Cells Macro

    Hi, attempted to create a code to hide all "0" cell rows in a given column. These cells consist of a lookup seeking mail dates that have not occurred yet in data, so they are returning a 1/0/1900 value for the time being. Came up with the following code. I am not liking the run time on it and...
  4. J

    Percentile formula not working properly

    Im doing up massive amount of data which will be continuously updated in near future, therefore im trying to create formulas that can aid me with my data keying and update accordingly. Now im stuck with the percentile formula, which im trying to get MIC50 and MIC90 from my raw data. However I...

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