FORMULA FOR TABLE
 

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

FORMULA FOR TABLE
 

how did you got the 4th Term or Trade or hold... On what basis u
derived that ?



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

FORMULA FOR TABLE
 

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

FORMULA FOR TABLE
 

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

FORMULA FOR TABLE
 

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