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?
=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?