|You can't enter an number and a formula in the same cell, so it can't be done within Excel itself.|
You would need VBA...maybe something like this...
Whatever number you enter in A1 will be added to B1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Range("B1") = Range("B1") + Target
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.