Override a cell that contains a formula

[JohnShaffer]

I have a base that I use to manage our shipping materials. The "Material's On Hand" is calculated by a formula. I would like to have the option to override this formula if I enter data in a form. The override field is titled "Cycle Count Override". I am currently using the below formula but as you can see from the screenshot it is unsuccesful.

IF({Cycle Count Override}, {Cycle Count Override}, {Material's Received}-{Material's used Rollup (from Outbound)})

[joshsorenson]

Try this route instead using Length, I don't think what you currently have will work as there is nothing to say if it is true or false. 

IF(
  LEN({Cycle Count Override}) = 0,
  {Materials Received} - {Materials used Rollup (from Outbound)},
  {Cycle Count Override}
)