What part of this IF statement is working

[joshnathan]

I just want it so that if a I = 2 the value in E20 doesnt appear.

=IF(AND(B20="",C20=""),"",IF( I19 = 2,A20&B20&D20&C20&" "&F20,A20&B20&D20&C20&" "&F20E20))

[zbor]

You missing &:
=IF(AND(B20="",C20=""),"",IF( I19 = 2,A20&B20&D20&C20&" "&F20,A20&B20&D20&C20&" "&F20&E20))

But you can also:

=IF(AND(B20="",C20=""),"",A20&B20&D20&C20&" "&F20&IF( I19 = 2,"",E20))

[joshnathan]

I cant get those to work either way i end up with the data from E20.

[joshnathan]

Look at the example in this sheetTest book1.xls

[zbor]

You have numbers stored as a text. So it won't work this way.
You can either add "2" instead of 2 and it will work.

=IF(AND(B20="",C20=""),"",A20&B20&D20&C20&" "&F20&IF( I19 = "2","",E20))

however, I would rather use numbers like: Instead of joining 2 and .1 into text 2.1 use 2 + 1/10 that will give you number 2.1

[joshnathan]

Thank you.
I will make the ammendments to the sheet now