Skip to Content
0

#Div/0 Error in Percentage

Mar 22 at 11:33 AM

15

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 22 at 11:35 AM
1

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

its became string and i cannt do percentage. even though i have writeen the formula as below

=If(IsError([Rtn% Qty])) Then "n/a" Else FormatNumber(([Rtn% Qty]);"0.00%")

capture1.jpg

capture1.jpg (13.5 kB)
0

if you need to display "n.a" then obvious it's going to be convert in the string.

replace "n.a" with 0 and try.

0

i dnt want to display 0

0