What the difference between functions and macros

Development Programming & Scripting Blueprint
1

Could you explain please in which cases I should prefer macros over functions