How to populate down the current formula automatically

[kvngo94]

Hello friends, 

Please see below shared spreadsheet, G.K.Help sheet, A2,D2,E2 cells 

Could you guys advise me with formulas in excel that works the same these formulas in spreadsheet ?

Thank you,

https://docs.google.com/spreadsheets/d/1D2Szd3_nPvtoDxNgrClKJH7cvstZ8YXZg-0rLo0Ddvs/edit?usp=sharing

[#2]

@kvngo94 Assuming you are going to need this in Excel for the Web. Otherwise you'll need the desktop version for MS365 or Excel 2021.

File attached.