conditional string value

Hi Expert

i am trying to get the value "-" if the cell is Null or 0. and have 0% based on the calculation

Desired output

I want to insert the conditional in following formula, after data cleansing i already have Null values as 0 but now i need to insert "-" to all ) values.

Data Investigation

Accepted answers

atcodedog05

Hi @pokhan27

Here is how you can do it.

Workflow:

Hope this helps : )

% change.yxmd

All comments

binu_acs

can you provide some sample input values and expected output values?

mnmemilymnm

Would an IF THEN ELSE formula work? I'm thinking something like:

if([32% /68% OTC and Appt Data]*100=0)

then "-"

else tostring(([32% /68% OTC and Appt Data]*100),0)+'%'

endif

pokhan27

Input:

OTC Data	Appt Data	OTC and Appt Combined
119%	168%	152%
39%	90%	73%
104%	90%	94%
99%	73%	81%
39%	47%	44%
55%	46%	49%
%	%	%

Output data

OTC Data	Appt Data	OTC and Appt Combined
119%	168%	152%
39%	90%	73%
104%	90%	94%
99%	73%	81%
39%	47%	44%
55%	46%	49%
0%	0%	0%

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703