Calculate sale price in excel

dear all,

 

i need your help.  pl find below one table  in which i want to find automatically price for a, b and c grade sale price
 
explanation:
a) average selling price is $5 (all of a,b,c grade products)
b) in this a grade product % is 55, b and c 40 and 5% respectively. suppose if we produce 100 kg then a grade is 55 kg and b grade 40 kg and c grade is 5 kg
c) b grade sale price is 10% lower than a grade
d) c grade price is 20% lower than b grade
 
what you have to do is you have to write/find a formula in excel to find automatically price of a, b and c grade price. suppose if you put average price as $6 then grade a,b, c price should be calculated automatically in excel
 
regards
sarawanan
 
sale price calculation
sale price   $5  
a grade product 55% 5.45  
b grade product 40% 4.91 -10%
c grade product 5% 4.36 -20%

 

Replies (3)

 

  A B C D
1     100           6.00
2 a 55% 55      330.00
3 b 40% 40      216.00
4 c 5% 5         24.00

 

 

In cell D2 type  =C2*$D$1

in cell D3 type =C3*$D$1*0.9

 

in cell D4 type =C4*$D$1*0.8

 

Where in cell c1 you have to put Quantity & D1 rate per unit.

 

Thanks!!

 
thanks for your reply. but see in my question in red color font. I need price like that. in your example it is not like that
Sarawananji, Attched file. Hope it works.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details