n/a error

[changing n/a error to 0 data]

Hello
I Have customized a column that has the formula for
retreving the values from the other columns and gives me a
value and that is great. What is disturbing is that
the n/a error is appearing on all cells that do not have matching data.
How do I remove the n/a eror value to display a 0 number

 

[Gérard Ducouret]

Hello,
Test the origin of the N/A error with an IIF function :

IIf( expression; truepart; falsepart )

Hope this helps,

Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris

"changing n/a error to 0 data" <changing n/a error to 0
(e-mail address removed)> a écrit dans le message de
news:[email protected]...

 

[JackD]

I have an example of how to work around this on my website:

http://masamiki.com/project/customfieldFAQ.htm

-Jack

Hello,
Test the origin of the N/A error with an IIF function :

IIf( expression; truepart; falsepart )

Hope this helps,

Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris

"changing n/a error to 0 data" <changing n/a error to 0
(e-mail address removed)> a écrit dans le message de

Hello
I Have customized a column that has the formula for
retreving the values from the other columns and gives me a
value and that is great. What is disturbing is that
the n/a error is appearing on all cells that do not have matching data.
How do I remove the n/a eror value to display a 0 number