2 IF statements on the same field
I am trying to add 2 unrelated IF statements to the same field.
The first statement makes "NA" appear in the field when another field is checked. The second makes the field auto populate with a value when a value is added to another field.
SO I need:
if field A is checked with a value (when the checkbox is checked), field B is auto-populated with "NA"
if a value is entered into field C, field B is auto-populated with "mmHg"
These are the 2 statements, placed into the auto-enter calculated value for field B, that work fine alone, but do not work when I try to put them in the same auto-enter calculation together:
Please help. Thank you