sir,thank you for your support, hear i explain my table if (C (BUY)=D (SELL)
)THEN
E(FUNCTIONREQUIRE ?) GOES TO "TRADE" SUCH AS ROW 2.
NEXT, (C (BUY)D (SELL) )THEN E(FUNCTION REQUIRE ?) GOES TO "HOLD" SUCH AS
ROW 3.
NEXT,IN ROW 4,(B(NAME AA),C (BUY 0),D(SELL 25 )THEN E(FUNCTION REQUIRE ?)
GOES TO "4TH" (4TH MEANS 4TH QUARTER BECAUSE IT A (DT) 12/1/08 )
NOW,IN ROW 1,A (DT(1/1/08) B(NAME AA), C (BUY 25),D (SELL 0) THEN
E(FUNCTION REQUIRE ?) GOES TO "4TH" (ACCORDING TO A (DT(1/1/08) IT SHOULD
TOGO "1ST" (MEANS 1STQUARTER BECAUSE IT A (DT) 1/1/08 )
BUT ,I REQUIRE "4TH"(BECAUSE IT SELL IN 4TH QUARTER)
"Shane Devenshire" wrote:

Hi,

If I understand your question, suppose your data starts in A1 with titles on
the first row:
=IF(MONTH(A2)<4,"4th",IF(MONTH(A2)<7,"Trade",IF(MO NTH(A2)<10,"Hold","4th")))
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"NARSARIA_RAJ KUMAR" wrote:

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