algorithm - How to implement in Excel: If cell A1 is 0, cell A2 = "foo". Else, let the user specify an input -


This is very straight forward if a certain cell, such as A1, has a value of "0", then I have a Must have arbitrary value. Otherwise, I want the user to be able to enter their own values. The first part is simple:

A2 = IF (A1 = "0", "value", "")

However, if A2 is empty , And the user goes to edit the value, Excel Formula presents itself to edit.

Is there a way around this?

There is a need to create slightly different perspectives instead of a formula # .0; # .0; Use something like "value" , then copy the value of A1 to A2 and use the custom number format on A2.


Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -