G
Guest
Guest
Is there a way to leave a resultant field blank when I have a simple computation done from input field but sometimes no input is made so I don't need anything to show up?
example:
I have a field1 that takes a number, then field2 that checks that number against a table, and may or may not compute another number against it. If I don't put a number in field1, I still get a #N/A or O in field2.
I'd like to get nothing in field2 if nothing was put in field1 although field2 does some math.
Thanks
example:
I have a field1 that takes a number, then field2 that checks that number against a table, and may or may not compute another number against it. If I don't put a number in field1, I still get a #N/A or O in field2.
I'd like to get nothing in field2 if nothing was put in field1 although field2 does some math.
Thanks