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
=if(iserror(variable)) then "n/a" else [variable]
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%")
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.
i dnt want to display 0