conditional string value

[pokhan27]

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. 

[binuacs]

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%

[atcodedog05 · Accepted solution]

Hi @pokhan27 

Here is how you can do it.

Workflow:

Hope this helps : )

[pokhan27]

always you are a life saver thank you. 

[atcodedog05]

Happy to help : ) @pokhan27 

Cheers and have a nice day!