Improve Efficiency of VBA Code

[jonsonbero]

Thanks a lot for your reply and kind help
Regardless of the formulas used, whether complicated or uncomplicated
The idea is to convert or replace these formulas to their values depending on many conditions through many drop-down lists
The code works perfectly and it gives exact results .. the only problem is that it takes long time to execute.
I welcome any ideas to improve the code, so any help at all would be massively appreciated!!!