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

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

- Why cant ISEVEN/ISODD functions be used in cond'l formating?
- Even and Odd
- Cannot use ISEVEN or ISODD functions in Conditional Formatting
- Conditional formating with isodd and iseven
- #name? error when using ISEVEN and ISODD formulas
- Cannot use ISEVEN or ISODD functions in Conditional Formatting
- Refining when a worksheet_Change event runs with perhaps ISodd or similar
- ISODD/ISEVEN functions on range of cells
- Copy 2 arrays into single array depending on the target element row/col is even/odd
- IsEven Method [Excel 2007 Developer Reference]
- IsOdd Method [Excel 2007 Developer Reference]
- IsEven Method [Excel 2007 Developer Reference]
- IsOdd Method [Excel 2007 Developer Reference]
- IsEven Method [Excel 2007 Developer Reference]
- Check if number is an Integer
- IsOdd Method [Excel 2007 Developer Reference]
- IsEven Method [Excel 2007 Developer Reference]
- Odd or even checking
- ISEVEN Conditional Format Error
- Even/odd number question
- ISODD and EVEN formula
- IF and ISODD Formula Help
- =ISODD Behaving Oddly
- Isodd formula does nt work. Any support on that.

=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!

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.

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

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

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!

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

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

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.

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 FunctionIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

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

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

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

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

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

Steve

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

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

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

Has anyone used ISEVEN in conditional formatting at all?

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,

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

B1 = input

B2 = input

Formula that is returning a #NAME? error is:

=IF(B1

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