how to replace the ( ) null value with 'N/A'

[#1]

can anyone help me in writing the below expression correct

my issue i need to replace the N/A with ' ' from one them but now i need to show N/A when both the expressions have N/A how can I write it can anyone help me.

=if([Results]='N/A','',[Results])  &''&

if([HI RESULTS ]='N/A','',[HI RESULTS])

[joshabbott · Accepted solution]

Just add the if for both = N/A before your script below, and make your script the 'else' piece

=if([Results] = 'N/A' and [HI RESULTS] = 'N/A', 'N/A',

  if([Results]='N/A', '', [Results]) & '' & if([HI RESULTS] = 'N/A', '', [HI RESULTS]) )

[avinashelite]

Hi,

If you want to replace the null with N/A then use.

if(isnull(fieldname), 'N/A',filedname)

[MK_QSL]

=if([Results]='N/A' and [HI RESULTS ]='N/A','N/A',

if([Results]='N/A' and [HI RESULTS ]<>'N/A',Results,

if([Results]<>'N/A' and [HI RESULTS ]='N/A',[HI RESULTS])))

[michael_maeuser]

hi, I don´t understand exatly but do you need this?

=if([Results]='N/A' and [HI RESULTS ]='N/A','N/A',[Results])

maybe you can explain a bit more detailed?

thanks!

Michael

[jjordaan]

Hi Apache77,

What Avinash is telling is correct.

But of you user applymap you can use the 3th parameter of applymap to display a certain Value if the Value is nul.

Hope this helps.

Best regards