Help which formula can be applied

[Mohammed ilyas]

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]

Mohammed ilyas
Why did You duplicated Your thread?

Seeking help

Please help me solving the questions

chandoo.org

Did You reread Forum Rules as You've asked to do?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Did You try to do something Yourself?
... if You did then - Where others could see what have You tried to do?

 

[Mohammed ilyas]

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

 

[vletm]

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.