Hi,

Thanks to the wonderful help from the people in here, I was able to update
an excel file. Now I hope everyone can help me again with two formula's.

There are 4 columns involved, 2 columns data is inputed and I would like to
automate the data to be inputed in the other 2 columns.

AF# data is either an "A" or "V" and AX# is either "1.0" or "1.1".

What I'm trying to achieve is, when AX# has either "1.0" or "1.1", I would
like AZ# to have "—‹" (this is the degree symbol) otherwise blank.

For BA#: if AX# is "1.1" then BA# is "-", but if AX# is "1.0" and AF# is
"A", then BA# is "—‹" (this is the degree symbol) and if AX# is "1.0" and AF#
is "V", then BA# is "-".

I hope I'm not confusing anyone with this. the # is the row number. Thanks
to anyone that is willing to take a look at this.