is there such a formula?

imherept

New member
Joined
Dec 30, 2013
Messages
2
Reaction score
0
Points
0
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:

NoS

New member
Joined
Jan 17, 2013
Messages
832
Reaction score
0
Points
0
Location
British Columbia
Excel Version(s)
Excel 2010
try this

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

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,779
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Excel also provides the FLOOR function.
Code:
=FLOOR(A1,2)
 

imherept

New member
Joined
Dec 30, 2013
Messages
2
Reaction score
0
Points
0
Thank you both for your help.
My excel is not in english so i'll try to find the translation for your formulas.
 
Top