timsea81
2010-03-24, 06:58 PM
Is there a way to do this? If the parameter type is expecting a number, the defaults are 0 or some negative number, and if I try to manually type something in it says "enter a value or a formula starting with "=".
Is there a way to write a formula whos output is text even though the parameter is something else? I tried ' = "n/a" ' but that didn't work.
I could get creative and come up with some solution (creating a new text parameter and hiding the irrelevant one in each case), but that seems like a lot of work and I'm hoping there's something simpler.
Is there a way to write a formula whos output is text even though the parameter is something else? I tried ' = "n/a" ' but that didn't work.
I could get creative and come up with some solution (creating a new text parameter and hiding the irrelevant one in each case), but that seems like a lot of work and I'm hoping there's something simpler.