My Formula bar was missing in Excel (Mac). Click on View > Formula Bar and the option was ticked. Tried on untick – but stayed ticked.
Closed all other tool bars, no help.
Found solution: hold down CONTROL and SHIFT keys and start Excel. Resets the tool bars and the Formula bar magically reappeared.