Solver in Excel in Hindi

You can use Solver to solve multiple variable problems. Let's look at this intersting situation: You have a Rs.200 voucher to spend on soap. A small (100g) soap costs Rs. 17, a large (250g) one is Rs. 32. Also, there's a special offer on the small soap: if you buy 3 you get one free. You want to buy as many soaps as possible and you want to spend every paisa as the shop doesn't give change for a voucher. How many of each sort should you buy?
Enter the following headers in your Excel worksheet: A1 B1 C1 D1 Soap Type Number Weight Cost.
Enter the following data in cells A2 to A7 A2 - Large A3 - Small A4 - Offer A5 - Total A6 - A7 - Budget
Enter the following data in cells B2 to B7 B2 =1 B3 =1 B4 =1 B5 =B3+4*B4 B6 - B7 - 200
Enter the following data into cells C2 to C5: C2 =B2*250 C3 =B3*100 C4 =B4*100 C5 =SUM(c2:C4)
In cells D2 to D5 enter the following data: D2 =B2*32 D3 =B3*17 D4 =B4*51 D5 =SUM(D2:D4)

Watch this training video on YouTube

Solver in Excel in Hindi