Hello all!
I will need some help. So, in my excel worbook there is a table with some ranges and amounts; there's a variable that can be changed by the user (E11) and a result that I would like to calculate with vba (E12).
The user of the workbook will only be allowed to change the cell E11 and, based on this cell, a calculation in E12 will be done automatically (with VBA, without the need of pressing a button).
I've attached the excel workbook.
The calculation would be the following:
If the value in yellow (E11) is lower than > 10.000, then E12= 0
If the value in yellow (E11) is > 10.000 and <20.000 , then the formula should be E12=E11*D5 -E5
If the value in yellow (E11) is > 20.000 and <30.000 , then the formula should be E12=E11*D6 -E6
If the value in yellow (E11) is > 30.000 and <40.000 , then the formula should be E=12E11*D7 -E7
If the value in yellow (E11) is > 40.000 and <50.000 , then the formula should be E12=E11*D8 -E8
If the value in yellow (E11) is > 50.000 then the formula should be E12=E11*D9 -E9
Anyone could help me?
Thank you very much.
Bookmarks