# 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

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

#### Mohammed ilyas

##### New Member
Hi..if u r willing to help just do..or else keep quiet if u don't know the answer...

#### vletm

##### Excel Ninja
Mohammed ilyas
I could copy Your original thread comments here, but I won't do so.
You should reread those Forum Rules.
This thread is close now.

Status
Not open for further replies.