Results 1 to 10 of 10

ISODD/ISEVEN functions on range of cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    ISODD/ISEVEN functions on range of cells

    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.
    Last edited by ElmerS; 06-25-2009 at 12:37 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1