I have selected a column. And i am totally stuck how to make a formula display this
If a cell in selected column has an even number, display the data in adjacent cell to the even cell.
Any ideas?
I have selected a column. And i am totally stuck how to make a formula display this
If a cell in selected column has an even number, display the data in adjacent cell to the even cell.
Any ideas?
Hi,
Can you post a sample file.
Regards,
use this formula =IF(MOD(C1,2)=0,C1,"") where c is your column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks