How to make these formula's?
 

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.

How to make these formula's?
 

In AZ#:
=IF(OR(AX1=1.1,AX1=1),"o","")
In BA#:
=IF(AX1=1.1,"-",IF(AND(AX1=1,AF1="a"),"o",IF(AND(AX1=1,AF1)="v", "-","")))

"Hell-fire" wrote:

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.

How to make these formula's?
 

Hi Tevuna,

Thank you very much. It works like a charm.

"Tevuna" wrote:

In AZ#:
=IF(OR(AX1=1.1,AX1=1),"o","")
In BA#:
=IF(AX1=1.1,"-",IF(AND(AX1=1,AF1="a"),"o",IF(AND(AX1=1,AF1)="v", "-","")))

"Hell-fire" wrote:

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.