CODEWITHSUNDEEP
excelif-statementexcel-formulamanualautomatic-properties
xaraj yawell
xaraj yawell

Reputation: 3

A method to use a formula if , and if not to tip a value manual inside, without VBA Excel

Hello and thanks for the help in advance.

Is there a way, for example, if cell A1 can say either yes or no, then I say in cell A2, if it says yes, then automatically write a word like "tree" in the cell, and if in cell A1 = no then the user should be able to describe/fill in the field in cell A2 manually. So far I haven't found a solution on how the formula doesn't disappear then. I don't want to use Excel-VBA here if possible. This would give me a solution, but since not everyone in my company has macro permissions, it would not be usable for everyone then..

Upvotes: 0

Views: 33

Answers (0)

Related Questions