={IF{bkmrk2}="E7""SFC""None"}
Everytime I try this or a variation of it, I get a syntax error.

The form is in a table, and what I want it to do, is autimatically fill in
other cells in the same table (on different pages) with the same data (text)
or replace certain text phrases with others.

The specifc action requested for the above formula is this: In a different
cell of the same table, I want to replace (the grade) "E7" with (the rank)
"SFC" for the purposes of creating a signature block.

Please Help! Thanks!