Hi all,

First I like to thank Max for all the help of my previous post. Second, I
like to thank the others for the help on my other posts I made a few months
ago.

I have a simular excel file that just has an extra addition, but with my
very limited understanding of how you guys make these formulas, I can't quite
make an adjustment that works.

Here are the cells involved and formulas:

Column B: is an identifier number from 1 to 500
Cell D: =CONCATENATE(E28,F28,G28,H28,K28,I28,K28,J28)
Cell E: =IF(BB28="—‹",IF(BD28="—‹","B","F"),IF(BD28="—‹ ","I","X"))
Cell F: =IF(R280,CONCATENATE(0,LEFT(R28,3)),"xxxx")
Cell G: =IF(AB28="R","R",IF(AB28="T","T",IF(AB28="A","A"," X")))
Cell H: =B28
Cell K: _
Cell I: =IF(ISBLANK(AC28)=TRUE,"xxxx",AC28)
Cell J: =IF(ISBLANK(AX28)=TRUE,"XXX",LEFT(AX28,3))
Cell AB will have values of either "A", "R", or "T"
Cell AZ will have value of either "1.0" or "1.1"
Cell BB will have value of either "—‹" or "-"
Cell BC will have value of either "—‹" or "-"
Cell BD will have value of either "—‹" or "-"
Cell BE will have value of either "—‹" or "-"
The "—‹" is the degree character, just in Japanese its a circle.

With no values inputted for this row Cell C looks like this:

XxxxxX014_xxxx_XXX

For what I need to be done is, when Cell AB has either "A" or "T" and Cell
AZ has 1.0, Cell BB, BC, BD and BE should have "—‹".
IF Cell AB has "R" and Cell AZ has 1.0, then Cell BB and BD have "—‹" and
Cell BC and BE should have "-".
Also when Cell AB has "A", beginning character in Cell C should start with a
"B", if Cell AB has "T" or "R", then the beginning character should be an "F".

Now, when Cell AZ has 1.1 and Cell AB has either "A" or "T", then Cells BB
and BCshould have "—‹" and Cells BD and BE should have "-".
If Cell AZ has 1.1 and Cell AB has "R", then Cell BB has "—‹" and Cells
BC,BD, and BD has "-".
Also when Cell AZ is 1.1, and Cell AB has "A", beginning character in Cell C
should start with a "1B", if Cell AB has "T" or "R", then its a "1F".

So for example, Cell AF is "A", Cell AZ is "1.0", then Cell C should be
"BxxxxX014_xxxx_XXX" and Cells BB to BE have "—‹"
or
If Cell AF has "T" and Cell AZ is "1.1", then Cell C should be
"1FxxxxX014_xxxx_XXX" and Cells BB and BC have "—‹", Cells BD and BE has "-".

For a different file with a simular setup, I was kindly given these formulas:

=IF(OR(AF445="",AX445=""),"",IF(AX445=1,IF(OR(AF44 5="A",AF445="V"),IF(AZ445="—‹",IF(BA445="-","F","B"),IF(BA445="—‹","I","X")),""),IF(AX445=1 .1,IF(AND(AF445="A",AZ445="—‹",BA445="-"),"1B",IF(AND(AF445="V",AZ445="—‹",BA445="-"),"1F",IF(AND(AF445="A",AZ445="—‹",BA446="—‹"), "1I",IF(AND(AF445="V",AZ445="—‹",BA445="—‹"),"1X ","")))))))

=IF(OR(AX445=1.1,AX445=1),"—‹","")

=IF(AX445=1.1,"-",IF(AND(AX445=1,AF445="A"),"—‹",IF(AND(AX445=1,A F445="V"),"-","")))

The Column letters are different, but the sheet format is fairly the same.
I hope I haven't confused or discouraged anyone from looking at this. Thank
you.