If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Formulating The Price with Various Condition and Counting
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Formulating The Price with Various Condition and Counting

#1
June 16th 12, 10:44 AM
 Xchoco Junior Member First recorded activity by ExcelBanter: Jun 2012 Posts: 2
Formulating The Price with Various Condition and Counting

I Get a problem with this Formula,plis some one may help me for this.

Demand CODE = A(Cell C2)---8(Cell E)---A(Cell G2)---3(Cell I2)

1st Code(Cell B4)---Price(Cell C4)---Total(Cell D4)
83(Cell B6)---100,000(Cell C6)---should be times(*) with 2(Cell D6)
C9(Cell B7)---200,000(Cell C7)---disc 10%(Cell D7)
C3(Cell B8)---50,000(Cell B8)---disc 10%(Cell D8)
A8(Cell B9)---150,000(Cell C9)---should be time(*) with 4(Cell D9)
B4(Cell B10)---250,000(Cell C10)---disc 10%(Cell D10)
G5(Cell B11)---100,000(Cell C11)---disc 10%(Cell D11)
K7(Cell B12)---50,000(Cell C12)---disc 10%(Cell D12)

my 1st problem is :
1. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit and second digit has 1 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (C6)" should be times (*) with 2
2. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit has a 2 same code and second digit has 1 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (C6)" should be times (*) with 4 {so with the opposite if first digit has 1 same code and second digit has 2 same code}
3. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit has a 3 same code and second digit has 1 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (C6)" should be times (*) with 6 {so with the opposite if first digit has 1 same code and second digit has 3 same code}
4. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit has a 2 same code and second digit has 2 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (B6)" should be times (*) with 6
5. if there is no same code or got only 1 same code in the first or second digit "1st Code Column (B6)" and "Code Column (C2,E2,G2 and I2) then the "Price Column (C6)" will get a 5% discount.

2nd Code(Cell B21)---Price(Cell C21)---Total(Cell D21)
83(Cell B23)---50,000(Cell C23)---disc 10%(Cell D23)
A8(Cell B24)---100,000(Cell C24)---disc 10%(Cell D24)
E3(Cell B25)---200,000(Cell C25)---disc 10%(Cell D25)
A3(Cell B26)---50,000(Cell C26)---should be times with 5(Cell D26)
81(Cell B27)---150,000(Cell C27)---disc 10%(Cell D27)
AE(Cell B28)---250,000(Cell C28)---disc 10%(Cell D28)

my 2nd problem is :
1.in the "Total Column (D23)" , I want the count is : if the "2nd Code Column (B23)" first digit has a same code with the "Code Column (G2) and the second digit has a same code with the "Code Column (I3)" then the "Price Colomn (C23)" should be times (*) with 5
2.if there is no same code then the "Price Column (C23)" will get a 10% discount

thanks for the help

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post counting non blank cells according to a condition hayleyho Excel Discussion (Misc queries) 6 June 28th 09 05:55 PM Counting values in column B in condition of A Nrechnitzer Excel Worksheet Functions 2 May 1st 09 08:44 PM formula for counting the occurence of more than one condition Dr Carl Excel Worksheet Functions 2 January 8th 08 09:45 PM Counting with a condition disregarding errors vsoler Excel Worksheet Functions 7 May 19th 07 10:04 PM Counting Values on a condition madeforidiots Excel Worksheet Functions 1 July 27th 05 12:40 AM

All times are GMT +1. The time now is 09:13 PM.