Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table formula | Excel Discussion (Misc queries) | |||
Table with formula | Excel Worksheet Functions | |||
table formula | Excel Worksheet Functions | |||
formula {=TABLE(G13;)} | Excel Worksheet Functions | |||
Trying to get formula to Do table | Excel Worksheet Functions |