FORMULA FOR TABLE

[NARSARIA_RAJ KUMAR]

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

 

[muddan madhu]

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

 

[Rick Rothstein]

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?

 

[Shane Devenshire]

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(MONTH(A2)<10,"Hold","4th")))

 

[NARSARIA_RAJ KUMAR]

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)