Hi,

I'm trying to wrap my head around a particular problem.   We have some number fields, and these fields need to produce 2 things:  The number entered if they are filled out, and if they are not filled out a -1 answer.

So far I am using the following statement, which accomplishes 1/2 the job (getting -1 as an answer if blank).   Does anyone know how to bring the entered number into the results, should the field be filled out?

IF(ISBLANK(My_number field), '-1', '0')

Thanks for any leads.

Hi,

I'm trying to wrap my head around a particular problem.   We have some number fields, and these fields need to produce 2 things:  The number entered if they are filled out, and if they are not filled out a -1 answer.

So far I am using the following statement, which accomplishes 1/2 the job (getting -1 as an answer if blank).   Does anyone know how to bring the entered number into the results, should the field be filled out?

IF(ISBLANK(My_number field), '-1', '0')

Thanks for any leads.