Hi

I think the following does what you want

=IF(AND(AX8=1.1,OR(AF8="A",AF8="V")),"1"&IF(AZ8="? ",
IF(BA8="-","F","B"),IF(BA8="?","I","X")),"")
I used row 8 when testing, so substituted for your # in the formula.
--
Regards

Roger Govier


"Hell-fire" wrote in message
...
Hi,

I need to edit a formula and don't really know how to do it. This was
made
by another person which is no longer here. I'll try my best to
explain what
it does.

This forumla interacts with 9 other cells, the default setting in
column C is:
XxxxxX###_xxxx_XXXxxxxx where column C = Column D # is an ID
number.
For example F0705V363_GML_MagAPACS

Column D =CONCATENATE(E#,F#,G#,H#,L#,I#,L#,J#,K#) # is the row
number
Column E =IF(AZ#="?", IF(BA#="-","F","B"),IF(BA#="?","I","X"))
Column F =IF(S#0, CONCATENATE(0,LEFT(S#,3)),"xxxx")
Column G =IF(AF#="A","A",IF(AF#="V","V","X"))
Column H =B#
Column I =IF(ISBLANK(AG#)=TRUE,"xxxx",AG#)
Column J =IF(ISBLANK(AM#)=TRUE,"xxx",LEFT(AM#,3))
Column K =IF(ISBLANK(AP#)=TRUE,"xxxxx"Left(AP#,5))
Column L =_

Column B has ID numbers in it.

Now what I need to do is add Column AX in this formula that takes
values
from both AX and AF. When AX has value of 1.1 and AF has either A or
V, I
need Column E to respond with a 1F or 1B, instead of just F or B.

I beleive I have to modify Column E's formula to do this. If your
confused,
please let me know and I will try to explain better. I thank everyone
that
may try to help me.