A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Formulating The Price with Various Condition and Counting



 
 
Thread Tools Display Modes
  #1  
Old June 16th 12, 10:44 AM
Xchoco Xchoco is offline
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 2
Default 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
Ads
 




Thread Tools
Display Modes

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

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 06:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.