<>0 formula with blank cells

[NJS1982]

Hi all, I have a formula that looks like this:

=IFNA(IF(A3="","",IF(AX3<>0,AX3&" / ","")&IF(AY3>0,AY3&" / ","")&IF(AZ3<>0,AZ3&" / ","")&IF(BA3<>0,BA3&" / ","")&IF(BB3<>0,BB3&" / ","")&IF(BC3<>0,BC3&" / ","")&IF(BD3<>0,BD3&" / ","")&IF(BE3<>0,BE3,"")),"")

The cells it is looking at - AX3,AY3,AZ3 etc. are all cells that contain a VLookup formula. Sometimes a value is displayed in these cells, sometimes it is blank (though not truly blank as it has the formula in it).

All I want the formula I have to do is say 'If cell AX3 is not blank, provide the value in cell AX3 with a / at the end, otherwise keep it blank".

However, it seems to pick up the 'blank' contents of of cell AX3, so it looks like this '/'.

Anyone know what I am doing wrong?

 

[Peter_SSs]

Ahhh, I think I was over complicating it! Taken another look this morning and you are right, goodbye big long formula and hello your snappy short one. Thanks!

OK, glad it became clear in the end.