PDA

View Full Version : txt list function excluding zero



rahullambe
08-27-2008, 12:08 PM
Hii

I m stuck wid the 1 formulae, please view attached file I am trying to skip zero cell in the list in E row n I want list of only those investors whose investment is more than or equal to 15.

mdmackillop
08-27-2008, 12:17 PM
=IF(C4>15,B4,"")