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: