FORMULA FOR TABLE

  • Thread starter Thread starter NARSARIA_RAJ KUMAR
  • Start date Start date
N

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
 
how did you got the 4th Term or Trade or hold... On what basis u
derived that ?
 
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?
 
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")))
 
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)
 
Back
Top