Prev: Formula Result is different from the shown result
Next: Microsoft 2007
From: Errko on 18 Mar 2010 09:51
Hi,

I´ve made a list i Data Verifying that should display the options 0 or 1.
0 just being the digit 0 and 1 being the formula =SUM(D3)+1.

How to I get 1 as an option in the list and avoid having to show the formula
in the list?

Thanks in advance.


From: Errko on 18 Mar 2010 10:34
I meant Data Validation, not Verifying. Just to clarify.

"Errko" skrev:

> Hi,
>
> I´ve made a list i Data Verifying that should display the options 0 or 1.
> 0 just being the digit 0 and 1 being the formula =SUM(D3)+1.
>
> How to I get 1 as an option in the list and avoid having to show the formula
> in the list?
>
> Thanks in advance.
>
>
 | 
Pages: 1
Prev: Formula Result is different from the shown result
Next: Microsoft 2007