I believe that I want to use something like this but it doesn't seem to work:

=IF(CC70,1,0)

I have also tried: =IF(CC7<"",1,0)

If the value in CC7 is greater than 0 then place the number 1 in the cell
otherwise plae a 0 in the cell.
If the value in CC7 has any value then place the number 1 in the cell
otherwise place a 0 in the cell.

CC7 usually contains a time value

Should this work?
I have tested various entries in CC7 but get no results.
I don't get any errors, just blank stares from the computer (-:


P.S. When working in the field when entering a conditional setting, I am
inclined to use the arrows to navigate the equation. Of course, the system
starts filling the equation with cell addresses.
Is ther a way to use the arrow keys in this situation?

--
Message posted via http://www.officekb.com