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...
Thank you for your response.
Yes this would however it leads me to another problem.
I have entered the formula into the column B.
How would I paste my values for single and double targets in this column so that it fills the blank cells?
"" is technically not not blank.
When I past my single and double target figures in the column, it overwrites the Loss formula.
I hope that this is clear
Yes this would however it leads me to another problem.
I have entered the formula into the column B.
How would I paste my values for single and double targets in this column so that it fills the blank cells?
"" is technically not not blank.
When I past my single and double target figures in the column, it overwrites the Loss formula.
I hope that this is clear
Michael,
either you use VBA - which I can't help you with - or you use two helper columns: one with the formula and the second for the manual input. In the final column you put them together:
=IF(Column_with_Input)<>"",Column_with_Input,Column_with_formula)
Michael Kwakye I agree with Detlef_Lewin. Some things will not be possible in one go.
If you had mentioned in your question that you want to paste values into the column, then my reply would have been different. It is always good to explain the whole picture.
I suggest you paste the values into a helper column, then use a formula to pull the helper column value if it is not blank, else do the calculation.
