Thread: How to place alternate text, depending a field value.

I have two alternate sentences, that I wish to place in a given field depending on the value of a different given field.

Example: F1 has the value of 1 or 2.

C1 has text "this is option 1"

C2 has text "this is option 2"

A8 is the target field, desired to have contents of C1 placed in it if F1 has the value of 1, if not, then A8 is to have contents of C2 placed in it.

What coding would be placed in A8 to make this happen. Microsoft Excel 2007.

Thanks

Larry

*