Results 1 to 4 of 4

Thread: is there such a formula?

  1. #1

    is there such a formula?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone. I hope someone can help me.

    I need to create a formula (if it exists) where a cell shows the lower even number of another cell which has an odd number. For example:
    I write 23,4 in a cell and need another to show 22; or write 57,9 and need it to show 56; or write 22,4 and need it to show 22. I need this formula to work with any odd number.

    Is this possible?
    Thanx in advance for any help.
    Ana
    Last edited by imherept; 2013-12-30 at 11:44 PM.

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    681
    Articles
    0
    Excel Version
    Excel 2010 64bit
    try this

    =IF(MOD(INT(A2),2)=1,INT(A2)-1,INT(A2))

  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,336
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Excel also provides the FLOOR function.
    Code:
    =FLOOR(A1,2)

  4. #4
    Thank you both for your help.
    My excel is not in english so i'll try to find the translation for your formulas.

Posting Permissions

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