If then formula

[Sasquatch2014]

I need a formula where the cell in a column can be either blank, the letter "I", or the letter "V"

If blank, adjacent cell should = "Active"
If I or V, adjacent cell should = "Term"

[Pete_UK]

This is marked as Solved - have you come up with a solution yourself, or got one elsewhere?

Pete