even numbers

  1. BlondieC

    Using Min Max need to further identify odd even values to go in specific cells

    Starting with this code provided by a helpful person on here. WorksheetA and column A will be constant. I think I need a dynamic reference where WorksheetB is as there will be multiple worksheets that I want to pull the values from and the range on each of the worksheets will be the same...
  2. C

    Writing IF statement for ODD numbers

    Hello! I am trying to figure out how to write an IF statement such as this IF (value in column A is ODD, then do this) IF (value in column A is EVEN, then do this) All in the same string. Suggestions?
  3. K

    Counting Even-Odd Numbers that are Less (or More) than a Certain Value

    Hello I have a row that consists of numbers. I want to count how many numbers in that row are odd, more than 20 and less than 40 in one and single formula! I would appreciate a respond Thanks in advance
  4. R

    Macro to dertime Odd/Even number

    Greatings folks... In column A, starting in row 2 through the end of the column, I have either a null cell or a whole number. I need to determine if this whole number is odd or even. Can anyone help? Thanks so very much...

Watch MrExcel Video

This Week's Hot Topics

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
Top