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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...