• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help which formula can be applied

Status
Not open for further replies.

Mohammed ilyas

New Member
Hi Experts,

Just trying to solve using sumifs formula plz guide other methods..

Find the total sell plan for products that are priced greater than 15000 and less than 15000?
The products have to be discounted in the following manner
a. all TVs with size 32 and lesser inch should have a discount of Rs. 750
b. all TVs with size greater than 32 inch should have a discount of 1000
Find the new price for each product and count of products in each of the above case case

ProductBrandSizeSmartSelling PriceSell Plan
Product 1Brand 1
32​
Smart
12,499​
1​
Product 2Brand 1
40​
Smart
17,999​
43​
Product 3Brand 1
43​
Smart
21,999​
40​
Product 4Brand 2
32​
Smart
13,999​
83​
Product 5Brand 3
32​
Smart
9,999​
65​
Product 6Brand 4
32​
Basic
8,999​
41​
Product 7Brand 3
32​
Basic
7,999​
13​
Product 8Brand 5<32Basic
6,499​
38​
Product 9Brand 6
55​
Smart
41,999​
54​
Product 10Brand 4
40​
Smart
16,999​
91​
Product 11Brand 5
32​
Basic
7,999​
22​
Product 12Brand 2
32​
Basic
11,999​
81​
Product 13Brand 5
32​
Smart
9,999​
65​
Product 14Brand 7
40​
Smart
16,999​
68​
Product 15Brand 8
32​
Smart
13,999​
70​
Product 16Brand 9
32​
Basic
7,999​
26​
Product 17Brand 7
43​
Smart
23,999​
44​
Product 18Brand 4
50​
Smart
26,999​
50​
Product 19Brand 3<32Basic
7,499​
91​
Product 20Brand 4
43​
Smart
22,999​
72​
Product 21Brand 10
32​
Basic
8,499​
70​
Product 22Brand 11
32​
Smart
13,999​
93​
Product 23Brand 1>55Smart
54,999​
47​
Product 24Brand 4
43​
Smart
25,999​
5​
Product 25Brand 11
50​
Smart
33,999​
78​
Product 26Brand 9
32​
Smart
9,499​
92​
Product 27Brand 12
32​
Basic
7,999​
89​
Product 28Brand 4
55​
Smart
36,999​
94​
Product 29Brand 10
32​
Smart
9,999​
22​
Product 30Brand 13
32​
Basic
8,499​
7​



 

vletm

Excel Ninja
Mohammed ilyas
Why did You duplicated Your thread?
Did You reread Forum Rules as You've asked to do?
Did You try to do something Yourself?
... if You did then - Where others could see what have You tried to do?
 
Status
Not open for further replies.
Top