00:01
Hello students, as you can calculate the total price for the amount of a unit in a cell c12 by using the formula as the if c12 is greater than 5, c12 into c36 into just the 36 into c12 into the 36.
00:25
If c12 is less than or equal to 10, then c12 into 34, 34 as if c12 is less than or equal to 30 with by c12 into 31.
00:49
So if c12 is less than or equal to 50 with a c12 into 26 as the c12 into 20.
01:01
So this formula as this formula uses the nested if function to determine the price per unit based on the quantity in a cell c12.
01:13
So it checks the quantity and they applies the corresponding price per unit.
01:19
So to create the as to create the vba function for the incrementing and the decrementing the cell of the e3 and the buttons to grow these functions as our first is to press the add and press f11 to open the visual basic for the application editor.
01:38
In that in that just select the worksheet where you want to add the buttons.
01:45
So select the worksheet over there.
01:48
And in that a worksheet paste this code where this code provides the appears to be an vba microns within the microsoft excel worksheet.
01:58
So these microns are designed to interact with the worksheet and manipulate the values in the cell c3.
02:04
So whereas first it activate as this is an event handler that gets the triggered when the worksheet is activated or the selected in the microns...