on 03-22-2018 11:33 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
=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%")
capture1.jpg
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.