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:
Excel also provides the FLOOR function.
Code:
=FLOOR(A1,2)
 
Thank you both for your help.
My excel is not in english so i'll try to find the translation for your formulas.
 
Back
Top