Welcome to Excel.

Perhaps you could explain what you want as a result of your "adding
data in different ways", because Excel may have the capability already
with a standard function. Writing a cell formula with "two functions
with a drop-down menu" sounds ... funky.