How to make these formula's?

H

Hell-fire

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.
 
T

Tevuna

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","-","")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top