From the chart you gave us, there does not seem to be a way do distinguish between a BUY and a HOLD (they both have a value greater than zero in the C column and a value of zero in the D column). Is there another column that you are not showing us that would allow us to know the difference?

--
Rick (MVP - Excel)


"NARSARIA_RAJ KUMAR" <NARSARIA_RAJ wrote in message ...
TABLE LIKE
A (DT) B(NAME) C(BUY) D(SELL) E(FUNCTION
REQUIRE ? LIKE) THISH)
1 1/1/08 AA 25 0 4TH
TERM(BUY IN 1ST TERM BUT SELL IN 4TH TERM
2 4/1/08 AB 10 10 TRADE
3 9/1/08 AC 25 0 HOLD
4 12/1/08 AA 0 25 4TH
TERM(SELL IN 4TH TERM)

SIR , GIDE FORMULA FOR COL E