Skip to Content
avatar image
Former Member

#Div/0 Error in Percentage

Hi,

i am dividing two number

-350/500

when i take the percentage i am getting #Div/0.

Instead of #Div/0 i want to show as n/a

capture.jpg

capture.jpg (12.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 22 at 11:35 AM

    =if(iserror(variable)) then "n/a" else [variable]

    Add comment
    10|10000 characters needed characters exceeded