Forum Discussion
Formula based on condition otherwise enter manually
Hi Everyone,
I am trying to solve a problem
Lets say that cells in Column A contain either "loss" "single target" or "double target"
In column B I want to enter data manually if th...
Hello,
well, you could use a formula and overwrite it manually, something like
=if(A1="loss",YourFormula,"")
Copy down. Now only the cells where column A has "loss" will show the result of your formula, and you can manually type over the formula in other cells.
Does that work for you?