Free Microsoft Excel 2013 Quick Reference

ISEVEN / ISODD

Hi,
If I had 4 columns of numbers and I wanted to test which rows had all even numbers or all odd numbers how would I write that formula?

Thanks


When I enter this in conditional formatting:

=ISODD($D10)

I get the following dialogue box error:

"You may not use references to other worksheets or workbooks for Conditional Formatting criteria."

I'm referring to a cell on the same sheet, what's the problem?

Thanks!

IS there a keyword in Visual Basic that recognizes whether a number is odd or
even.
Could you explain a little more on how to call these functions and an example
of code for them. How to set a reference to the Analysis toolpak for
iseven(), isodd()? Thanks in advance.

Attempting to use the ISEVEN() or ISODD() functions in Excel 2003 SP2 for
Windows or Excel 2004 for Mac OS X within a Conditional Formatting formula
produces the error:

"You may not use references to other worksheets or workbooks for Conditional
Formatting criteria."

Even though the formula works fine in a cell, the Conditional Formatting
glitch happens even with a new Excel file using a generic test formula such
as: =iseven(2)

These functions would be useful in Conditional Formatting to produce
alternating row formats (shading) for entire columns efficiently instead of
applying a defined style, which for entire columns will tend to greatly
degrade file performance.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD

Why am I getting this error?

Excel doesn't seem to recognize this formula at all.

=ISEVEN(C2) results in this error, as does =ISEVEN(3). Doesn't matter the value. Same goes for ISODD. Even when I format the target cell as a number.

Help please! Thanks!

Attempting to use the ISEVEN() or ISODD() functions in Excel 2003 SP2 for
Windows or Excel 2004 for Mac OS X within a Conditional Formatting formula
produces the error:

"You may not use references to other worksheets or workbooks for Conditional
Formatting criteria."

Even though the formula works fine in a cell, the Conditional Formatting
glitch happens even with a new Excel file using a generic test formula such
as: =iseven(2)

These functions would be useful in Conditional Formatting to produce
alternating row formats (shading) for entire columns efficiently instead of
applying a defined style, which for entire columns will tend to greatly
degrade file performance.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

Thank you to Bob Phillips for getting me this far.

I am having problems with refining when code runs.

this is the code so far
Private Sub Worksheet_Change(ByVal Target As Range)

    On Error GoTo ws_exit
    
    
    Application.EnableEvents = False
    
    With Target
    ' I need a further condition then ensures the trigger column is one that needs this done
    ' the column at row 8 will be marked with another * but hidden with a white font on white
    ' then to complicate it further the row number must be greater than or equal to 9 and odd
    ' Finally cell(L3) should indicate a valid row and column with for example the word valid
    '
    If IsOdd(Target.Row) Then
    
        If .Value = "*" Then
        
            '
            ' This Should run if the user is to choose * from the drop down list
            '
            Dim Start_time As String ' Set Shift Start Time
            Dim Finish_time As String ' Set Shift Finish Time
            Start_time = Inputbox("Start Time", "MANUAL ENTRY MODE 1 of 2") ' Input The Start Time
            .Offset(0, 1).Value = Start_time ' Update cell with the entered start value
            Finish_time = Inputbox("Finish Time", "MANUAL ENTRY MODE 2 of 2") ' Input The Finish Time
            .Offset(0, 2).Value = Finish_time ' Update the cell with the entered Finish time
        Else
        
            .Offset(0, 1).Formula = "=VLOOKUP(" & .Address & ",$AY$9:$BB$20,3,FALSE)"
            .Offset(0, 2).Formula = "=VLOOKUP(" & .Address & ",$AY$9:$BB$20,4,FALSE)"
        End If
    End If
    End With

ws_exit:
    Application.EnableEvents = True
End


End Sub
Whilst this code works perfectly it does not give me the flexibility of being able to be more specific as to when it runs

I can place a marker in a column (at row 8 for example) which i will simply hide by making it the same colour as its background.
then the code needs to run only when the row is an odd value ant within a certain range (eg from 9 to 21)
I suspect i need to use the Isodd or iseven syntax but i am struggling as to how

This or a very similar post has been placed in Mr Excel also but i seem to be unable to access their site cureently so i am unable to link (currently)

As i am TRYING (slowly) to learn as i go PLEASE rather than just fix my issue notate things and hopefully one day i will be more capable.

Thank you in advance

Hi,

I would like to sum all EVEN values in the range A1:A50 and found out that it is very easy task with:

{=SUM(IF(MOD(A1:A50,2)=0,A1:A50))}

I tried to investigate what the: {=ISEVEN(A1:A50)} will return and got an error.

Is there a way to use ISEVEN to accomplish my request ?

Thanks, Mike

P.S.
To all of you who wonder - this is not a High-School Exercise - it is purely my curiosity.

I want to use VBA to copy the contents of two arrays into one array.

If the target array column row and column are both odd, I want it to copy from array 1.

If the target row and column are both even, I want it to copy from array 2.

Otherwise, the target array elements should be blank

Array 1 and 2 are the same size. The new array is of dimension 2r x 2c

For example: If 1 and 2 are both 2x2, then the new array is 4 x 4

If arr 1 = a b
c d

arr 2 = e f
g h

New array =

a - b -
- e - f
c - d -
- g - h

Attached is a worksheet version of what I want to do.

Here is the code I've been working on:


	VB:
	
 
Function IsOdd(x As Integer) As Boolean 
    IsOdd = (x Mod 2)  0 
End Function 
Function IsEven(x As Integer) As Boolean 
    IsOdd = (x Mod 2) = 0 
End Function 
Function rain(arr1, arr2) 
    mrows = Application.Max(arr1.Rows.count, arr2.Rows.count) 
    mcols = Application.Max(arr1.Columns.count, arr2.Columns.count) 
    b.Rows = 2 * mrows + 1 
    b.cols = 2 * mcols + 1 
    Dim brent 
    Redim parade(1 To b.Rows, 1 To b.cols) 
    Dim i As Integer 
    Dim j As Integer 
    For i = 1 To b.Rows 
        If IsOdd(i) Then 
            For j = 1 To b.cols 
                If IsOdd(j) Then 
                    parade(i, j) = arr1(2 * i - 1, 2 * j - 1) 
                Else 
                    If IsEven(i) Then 
                        For j = 1 To b.cols 
                            If IsEven(j) Then 
                                parade(i, j) = arr2(2 * i - 1, 2 * j - 1) 
                                 
                                rain = parade 
                            End Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


IsEven Method [Excel 2007 Developer Reference]

The value arguments of the IS functions are not converted. For example, in most other ... Lookup Method Match Method Max Method MDeterm Method MDuration Method Median Method

IsOdd Method [Excel 2007 Developer Reference]

The value arguments of the IS functions are not converted. For example, in most other ... SumIf Method SumIfs Method SumProduct Method SumSq Method SumX2MY2 Method SumX2PY2 Method

IsEven Method [Excel 2007 Developer Reference]

The value arguments of the IS functions are not converted. For example, in most other ... SumIf Method SumIfs Method SumProduct Method SumSq Method SumX2MY2 Method SumX2PY2 Method

IsOdd Method [Excel 2007 Developer Reference]

Value can be a blank (empty cell), error, logical, text, number, or reference value, or a ... The value arguments of the IS functions are not converted. For example, in most other ...

IsEven Method [Excel 2007 Developer Reference]

Value can be a blank (empty cell), error, logical, text, number, or reference value, or a ... The value arguments of the IS functions are not converted. For example, in most other ...

I know there is an ISODD and ISEVEN and other IS functions but I haven't found an easy way to write a formula that evaluates whether the number is an integer or not. If anyone knows a simple way, please let me know. Thanks!

Steve

IsOdd Method [Excel 2007 Developer Reference]

The value arguments of the IS functions are not converted. For example, in most other ... CountIf Method CountIfs Method CoupDayBs Method CoupDays Method CoupDaysNc Method

IsEven Method [Excel 2007 Developer Reference]

The value arguments of the IS functions are not converted. For example, in most other ... CountIf Method CountIfs Method CoupDayBs Method CoupDays Method CoupDaysNc Method

Hello,

Sorry about the pun in the title.

Did Microsoft do this for a reason. But it seems to me there is no built in formula to check weather a number is odd or even.

=isodd(A1) or =iseven(a1) would be nice.

curent if I have to do something like, which works but is a lot of effort.

=IF(A1/2=INT(A1/2),"Even","Odd")

Anyone with some ideas.

Thanks,
Ross

I am experiencing a problem with Conditional Formatting. I am trying to format a Column based upon a cell value being even. When I make the conditional format, FORMULA IS = ISEVEN($A3), i am getting the error "You may not use references to other worksheets or workbooks for Conditional Formatting criteria"

Has anyone used ISEVEN in conditional formatting at all?

Hi, everyone
I would like to know if its possible to extract just the even/odd pairs from a number.

Exp. I have the number 123 in cell A1, and would like to extract the even/odd pair, which in this case would be 13, the cell A2. I would like to be able to do this without the use of "Isodd" or "iseven" functions. Any help on this would be greatly appreciated.

Thanks,

=IF(isodd(SUM(Q6/$C$3)),EVEN(R6))

I have this formula in cell R6. I want it to basically sum q6/c3 and if the
answer is an ODD number change it to an EVEN number. In that same cell "R6"

Any help! :0)

Bonnie

First time posting a question...

B1 = input
B2 = input
Formula that is returning a #NAME? error is:
=IF(B1

I use the following macro in Sheet 3:-

Sub counter()
Dim C As Integer
Do Until Range("c8").Value = 7
Calculate
C = C + 1
Cells(8, 4) = C
Loop
End Sub

In Sheet 2 I have a set of =If(Isodd(*data*),1,0) and the result of these
*If* statements changes the *value =7* parameter in the above loop

The *data* are randomly generated variables held in Sheet 1 that need to be
re-calculated by the macro until Value=7( note: I only need to re-calc this
sheet's data - all other sheets' calcs are based on Sheet 1 values)

My problem is that when I run the macro all the =If(isodd(.....)s results in
Sheet 2 change to a VALUE! error - even though the data are and remain
numerical [ according to Excel Help this can only happen if the *data* are
non-numeric]

What am I doing wrong ? Should the re-calc be only applied to Sheet1 and how
do I do that?
Also how do I ensure that only Cells(8,4) of Sheet 3 is written to i.e. if I
launch the macro from another sheet its Cells (8,4) is written to.

Many TIA

Craig

isodd formula does nt work. Any support on that.