Net Force apply in Unity?

So say I have a rigidbody falling with gravity being -9.81 m/s/s and I have another force applied upwards at the same magnitude. When I try that in Unity, the rigidbody is still forced upward, yet shouldn’t the net force be zero, therefore the rigidbody shouldn’t move?

Isn’t Force = mass x acceleration? And isn’t gravity -9.91m/s/s an acceleration?