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