Hide formula in list

E

Errko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Supress DIV/0 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Random names from short list 4
IF AND Nested Functions - Formula Not Working 0
conditional formula needed 2
Difficulty with Sum+IF Function 10
Count zero values before specific date 6
If 0 then blank 8

Top